Ignore option for database/server in synonyms not working
ElliotRodriguez
Posts: 37
I am pulling new synonyms in from one source to another via SQL Source Control. We are not using Compare at this stage as its a promotion from DEV to our local TEST database.
Although I have "Database and server name in synonyms" checked under the Ignore options, Get Latest fails, complaining that the script cannot find the server in sys.servers.
Is there another setting I need to specify to get the ignore to work correctly?
Although I have "Database and server name in synonyms" checked under the Ignore options, Get Latest fails, complaining that the script cannot find the server in sys.servers.
Is there another setting I need to specify to get the ignore to work correctly?
Comments
Thank you for your forum post and sorry for the delay in replying to you.
Can you please confirm the exact version of SQL Source Control you are using?
Version of SQL Server the database you are source controlling?
Would you be able to locate the SQL Source Control log file from the period that the reported problem occurs? If the answer is yes, please attach to an email and send it to support@red-gate.com and in the subject field enter support call #49989.
You will find the log files in this path:
C:Users<User Name>AppDataLocalRed GatelogsSQL Source Control 3
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com