What are the challenges you face when working across database platforms? Take the survey

Preventing SQL Compare from DROP and CREATE SYNONYM

tobintobin Posts: 8 New member
Hey all,

We have a reporting database where on the live server we point our synonyms at [Production].[dbo].[tblName], but on our replicated server we use [Reports].[Production].[tblName].

When I try to use the sql compare cmdline tool to deploy a view or stored procedure, it seems to want to DROP and CREATE SYNONYM, but it uses the database, schema and table name from the source database.

Is there a way to prevent it from deciding to DROP and CREATE the synonym dependencies?


Sign In or Register to comment.