How to prevent dropping the objects from target database, which are not available in source database
Maggi
Posts: 1 Bronze 1
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.
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
Answers
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.
Tianjiao Li | Redgate Software
Have you visited our Help Center?