Skip to Content
0

Problem with PowerDesigner SQL Server Synonyms

Nov 14, 2016 at 07:41 PM

28

avatar image

In PowerDesigner PDM, I can create a SQL Server 2014 Synonym using the dialog box, however the generated script does not include the target database (schema and object name are present and correct) when the base object is in a different model. Additionally, I see from the DBMS resource for SQL Server 2014 that the reverse engineering script for a synonym parses out the schema and object name, *but not* the server or database name of the target object. Is there a way to make this work for cross-database synonyms?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers