Don't drop tables on target database

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Don't drop tables on target database

Postby sbacheld » Fri May 03, 2013 5:17 am

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
sbacheld
 
Posts: 4
Joined: Wed Apr 24, 2013 8:01 pm

Postby Anu Deshpande » Mon May 06, 2013 1:03 pm

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.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby sbacheld » Mon May 06, 2013 11:26 pm

Thanks, Anu. That did the trick
sbacheld
 
Posts: 4
Joined: Wed Apr 24, 2013 8:01 pm

Postby Anu Deshpande » Tue May 07, 2013 9:53 am

I am glad it worked :)
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby henxxx » Tue May 14, 2013 12:52 pm

Got the same issue here and I followed anu's instruction and it really works! thanks Anu!
--henxxx
Last edited by henxxx on Thu May 16, 2013 4:37 am, edited 1 time in total.
henxxx
 
Posts: 1
Joined: Tue May 14, 2013 12:24 pm

Postby Anu Deshpande » Tue May 14, 2013 1:08 pm

That's great henxxx :)
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron