Ignore option for database/server in synonyms not working

ElliotRodriguezElliotRodriguez 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?

Comments

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Hi

    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.