Red Gate forums :: View topic - Don't drop tables on target database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Don't drop tables on target database

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sbacheld



Joined: 24 Apr 2013
Posts: 4

PostPosted: Fri May 03, 2013 5:17 am    Post subject: Don't drop tables on target database Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Mon May 06, 2013 1:03 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
sbacheld



Joined: 24 Apr 2013
Posts: 4

PostPosted: Mon May 06, 2013 11:26 pm    Post subject: Reply with quote

Thanks, Anu. That did the trick
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Tue May 07, 2013 9:53 am    Post subject: Reply with quote

I am glad it worked :)
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
henxxx



Joined: 14 May 2013
Posts: 1

PostPosted: Tue May 14, 2013 12:52 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Tue May 14, 2013 1:08 pm    Post subject: Reply with quote

That's great henxxx :)
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group