Preventing SQL Compare from DROP and CREATE SYNONYM

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?

tobin August 10, 2021 02:57

Comments

2 comments

Hi,

Yes, you can use a filter file that excludes synonyms.

For more details please see: https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line#Switchesusedinthecommandline-/Filter

Sergio R August 11, 2021 11:52

0
Thanks Sergio, I was testing that out and noticed that I made a mistake by including the Default options, which has IncludeDependencies as part of it. Removing the defaults took out the synonym issue.

I appreciate you getting back to me.

tobin August 12, 2021 09:16

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Preventing SQL Compare from DROP and CREATE SYNONYM

Comments

Add comment