Don't drop tables on target database

sbacheld

Hi,

I am wondering if it's possible to prevent dropping tables in the target database when running SQL Compare from the command-line.

Thanks,
Sean

Anu D

Thanks for your post Sean.

You can use /Exclude switch to do this. This switch is explained in depth here.

So it should be /Exclude: Additional and hopefully this should stop SQL Compare from deleting objects from Target which are not present in the source.

Hope this answers your question.

sbacheld

Thanks, Anu. That did the trick

Anu D

I am glad it worked

henxxx

Got the same issue here and I followed anu's instruction and it really works! thanks Anu!
--henxxx

Anu D

That's great henxxx