Anybody using SQL Source Control from Red Gate

views:

154

answers:

+8 Q:

Anybody using SQL Source Control from Red Gate

Hi all,

We have been looking into possible solutions for our SQL Source control. I just came across Red Gates SQL Source control and wondered if anyone has implemented it? I am going to download the trial and give it a shot, but just wanted to see if others have real experience.

As always greatly appreciate the input

--S

+4 A:

I use SQL Compare for generating scripts when going from dev -> test -> production and it saves me tons of time.

For source control though, we use SVN and ScriptDB (http://scriptdb.codeplex.com/) though. I mainly use source control of SQL scripts for keeping track of changes. I think that rolling back a version of the database seldomly (if ever) works since data may have changed when making structure changes.

This works fine for a few of our current projects (largest is 200 tables and 2000 sprocs). The main reason for doing this though is cost since not all team members have to buy SQL Compare (I avoid adding dependencies to commercial projects unless really needed).

Andreas Paulsson 2010-08-25 12:40:37

I guess you could always use Red-Gate SQL Data Compare for reference tables, it's a pain either way though.

adolf garlic 2010-08-26 13:02:41

As You say, it works pretty good for reference tables, but if You are modifying the structure of a entity table (e.g. Customers) or alter associations, then You are in trouble when it comes to recreation of an old version of the database.

Andreas Paulsson 2010-08-26 14:51:53

We hope to support Static Data from the SQL Source Control UI in v2.0. We recognise that although it is possible to use SQL Data Compare, SSMS integration will greatly improve the user experience.David Atkinson, Red Gate Software.

David Atkinson 2010-08-27 20:11:20

ansaurus

tags:

views:

answers:

Anybody using SQL Source Control from Red Gate

related questions