How to prevent dropping the objects from target database, which are not available in source database

MaggiMaggi Posts: 1 Bronze 1
edited September 25, 2018 1:40PM in SQL Compare Previous Versions
How can we exclude the objects through command line,restrict the dropping objects which are not in source.
i was tried using " Exclude : Additional", but command line was not working with this command.Could you please tell me the why to prevent the objects dropping from target database.
The following command i am using now.
cd /d "C:\Program Files (x86)\Red Gate\SQL Compare 13"
sqlcompare /project:"E:\\RedgateProjects\SQL\Dev_Blank v cIMSDev.scp" /include:Identical /Synchronize


  • Options
    Hi @Maggi

    I'm afraid there is not a simple option to ignore target only objects. There is a post on our user voice forum already, so please go ahead and vote for it.

    The workaround is you need to filter out the objects that only in target database in the SQL Compare project.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.