Skip to Content
avatar image
Former Member

Problem with PowerDesigner SQL Server Synonyms

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers