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

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

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

Postby JoeCool1986 » Mon Mar 12, 2012 6:26 pm

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
JoeCool1986
 
Posts: 1
Joined: Mon Mar 12, 2012 4:40 pm

Postby David Atkinson » Mon Mar 12, 2012 6:47 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests