Red Gate forums :: View topic - Why buy SQL Compare if I already have SQL Source Control?
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

Why buy SQL Compare if I already have SQL Source Control?

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



Joined: 12 Mar 2012
Posts: 1

PostPosted: Mon Mar 12, 2012 6:26 pm    Post subject: Why buy SQL Compare if I already have SQL Source Control? Reply with quote

If I already have SQL Source Control, and can use "Get Latest" to deploy changes to production, What's the primary reasons to get SQL Compare? Any time I need to have a complex migration that I can't simply do "Get Latest" on, it seems I should save the money and just write the script myself, since from what I can tell, even with SQL Compare you still have to write the migration script yourself. So what makes SQL Compare compelling if I already have SQL Source Control?

Thanks,
-Robert
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Mon Mar 12, 2012 6:47 pm    Post subject: Reply with quote

If you want to get the latest from source control do a development or test environment and are willing to 'just do it' via Get Latest, this is fine. Doing so to Production is not recommended at all. Source Control (and hence SQL Source Control) is designed for development environments. Not only do you not get to review the differences in a detailed manner, but in order to detect changes, the tool will run frequent queries against your default trace not designed to be run against a production environment. Future releases may further instrument the database to provide richer functionality that is only pertinent to development environments. This additional load may have an adverse impact on your live database. Please consult your DBA and seek permission if you have no choice by to link a production database.

If you are pushing changes to Staging or Production, it is a best practice to generate a SQL script with SQL Compare.

SQL Compare also benefits from a sophisticated deployment experience, including a detailed difference viewer, object filtering, reporting, and many more features designed to ensure your deployment goes as smoothly as possible.

Let me know if this doesn't answer your question.

Kind regards,

David Atkinson
Product Manager
Red Gate
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