Red Gate forums :: View topic - Source Control Comparison
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation

Scream forum

Source Control Comparison

Search in Scream forum
Post new topic   Reply to topic
Jump to:  
Author Message
warthenr



Joined: 02 Oct 2007
Posts: 14

PostPosted: Tue Oct 02, 2007 3:34 pm    Post subject: Source Control Comparison Reply with quote

I think this tool is a lot of what I am looking for. If it could just point to a Source control system and check files in and out as part of it's "sync", it would be perfect.

It would also be helpful if it could sync up with the database scripts instead of with snapshots and/or with live databases. This tool ultimately should be integrated with SQL Compare and/or the multi-server tool.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
David Atkinson



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

PostPosted: Tue Oct 02, 2007 4:18 pm    Post subject: Reply with quote

SQL Compare 6 Pro can already synch to a scripts folder. The only bit missing is the auto-checkout feature.

SQL Compare 6.2 Pro, which is out soon, will have auto-checkout source control integration. For this initial release we will be supporting VSS and TFS. Which source control system do you use?

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
warthenr



Joined: 02 Oct 2007
Posts: 14

PostPosted: Tue Oct 02, 2007 4:26 pm    Post subject: Reply with quote

I use Source Safe currently, but planning on adding either AccuRev or SubVersion. However, ultimately what I need is a capability to keep history of changes to servers (some of them remote) and to be able to see where servers are out of sync. Knowing the history of a server and keeping them in sync ultimately seem to be the end goal of a lot of the requests I've seen in the forums (in the VERY short time I've been here). You may be interested in partnering with a company to resell the tool that can show the changes, branches and merging of the various objects. Twisted Evil Boy now THAT would be the ultimate.

But to come back to earth, having Source Safe Integration would be very helpful. Very Happy I'm looking forward to this release.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
David Atkinson



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

PostPosted: Tue Oct 02, 2007 4:40 pm    Post subject: Reply with quote

If you use a source control system that uses Edit-Merge-Commit such as Subversion, you won't need source control integration because you simply let SQL Compare 6 Pro synch to your working folder, and then invoke the changeset of your source control client to commit. This will deal with any necessary merges, which will only be an issue if someone else has modified the same objects.

I'm curious to know what you mean when you ask for changes, branches and merging. Surely this is dealt with by the source control tool. Don't forget, when using a scripts folder, all your objects are simply .sql text files which are treated in the same way as any other files in your source control system.

SQL Compare 6 Pro is simply a tool that lets you treat a scripts folder in the same way as you would treat a real live database. You can synch from a scripts folder to a live database as well as synch from a live database to a scripts folder. You can even synch from a scripts folder to a scripts folder.

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
David Atkinson



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

PostPosted: Thu Oct 25, 2007 2:43 pm    Post subject: Reply with quote

SQL Changeset has now been released as part of SQL Compare 6.2 Pro.
This provides integration between SQL Compare and source control when synching from a live database to a source-controlled scripts folder. The supported source control systems are VSS and TFS, although other SCCI-compliant systems should also work.

Check for Updates from SQL Compare should provide you with a link to the upgrade. Please post your feedback to the forum

Thanks,

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