SQL Script versioning


I would like to know the usability of Team foundation server in maintaining the sql server object versioning and development. Is there a better tool?



more ▼

asked Apr 14, 2011 at 12:32 AM in Default

avatar image

11 1 1 1

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

I have no experience of TFS but use Red Gate SQL Source Control with SVN (www.red-gate.com/products/sql-development/sql-source-control/) and it all works very well.

more ▼

answered Apr 14, 2011 at 12:37 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

Does Red Gate SQL Source Control with SVN connect to SQL databases directly? Can it be used for data also?

We are looking at a common product for the .net codes, sql scripts, SSIS packages etc. Will Red Gate SQL Source Control with SVN help in all of these?

Apr 14, 2011 at 12:42 AM Deepa

Have you looked at the link in the answer? Yes, some data can be maintained with SSC. The explanation of how it works is too big for this forum, you would be better off speaking to Red Gate directly. Try the application for the free 14 days and see if it works as you need it to.

Apr 14, 2011 at 12:53 AM Fatherjack ♦♦

you can also point Redgate's SQL Source Control at TFS - it basically doesn't care what source control system you use.

Apr 14, 2011 at 12:58 AM WilliamD

@Deepa. Databases directly, yes. TFS, yes. SQL Scripts, yes. Data, yes. .NET code, no. SSIS, no. SSRS, no.

Don't get hung on SVN. We use it, but we work with TFS, VSS, SVN, and any other source control system that can you define a command line interface for.

Apr 14, 2011 at 05:15 AM Grant Fritchey ♦♦

I know of a site where command line integration is working between SSC and AccuRev.

Apr 14, 2011 at 05:38 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

We use TFS 2010 for all source control, including SQL scripts. TFS by itself works just fine for storing and tracking versions, but things really work well if you have Visual Studio 2010. Certain editions of 2008 let you create and maintain database projects, which worked but were really slow, somewhat buggy, and not quite feature-complete. 2010 improved on all three dimensions, and it is now good enough that we are able to use it for all of our projects.

With the database project, you can edit a TFS build definition to deploy database projects, so you can also have database deployment and changes as part of an automated build process. Admittedly, this was a bit daunting at first, especially because it's hard to test changes, but there are websites which can help you out with that.

more ▼

answered Apr 14, 2011 at 03:55 AM

avatar image

Kevin Feasel
6.2k 4 8 15

(comments are locked)
10|1200 characters needed characters left

I have used both TFS and Red Gate SQL Source Control. They are different tools with different philosophy's behind them. However, the best advice I can give you is to get a copy of the Red Gate SQL Server Team-based Development book. It's free as an e-book. I wrote the articles on database deployment and source code management and tried to put as much of what I knew about both these tools into those chapters. I think it will help.

The only thing I will add, you, everyone, should be getting their dtabase into source control. I'd prefer you did it using Red Gate tools, but regardless of how you do it, you should do it. Here's a blog post on why I believe this.

more ▼

answered Apr 14, 2011 at 05:13 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

(comments are locked)
10|1200 characters needed characters left

We also use TFS to control all our development projects. It does work really well for us - we are a software house that have a team of developers and there are times when more than one of use needs access to the same project at the same time. TFS makes it easy as you can "branch" off projects and then merge them all together again at the end.

more ▼

answered Apr 14, 2011 at 06:14 AM

avatar image

51 4 4 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 14, 2011 at 12:32 AM

Seen: 2248 times

Last Updated: Apr 14, 2011 at 12:36 AM

Copyright 2018 Redgate Software. Privacy Policy