November 18, 2008 at 11:23 pm
I have to implement SQL Database version control..
I have Micosoft visual source safe 6.0 and also have Redgate SQL Compare Pro edition...
But i don't know how to configure for SQL Database???
Please needful to me..
November 19, 2008 at 1:10 am
I have not used the pro edition of sql compare, but have used older versions and it was very good for finding differences between two databases but I would not have called it version control. Never been a great lover of sourcesafe but have used Subversion to good effect. It needs (as do all version control mechanisms) some discipline but allows you to track every change to the db, stored procs etc.
Mike John
November 19, 2008 at 8:27 am
I recommend you to visit the Red Gate website for support, and their forum is great at answering questions
http://www.red-gate.com/MessageBoard/viewforum.php?f=81&sid=3ce1593f0857f1f155d85e78bac7db82
I believe to integrate SQL Compare with Version Control software, you may need the Changeset software
November 19, 2008 at 9:52 pm
November 20, 2008 at 3:43 am
I have two machine , one is server and oter is local machine..
I have created one project ifor one database SQL files of all objects of database in SQL Server 2005 Solution explorer on Server machine..
But in local machine i don't have soplution explorer due to express edition..so i can not open the project whcich i have created on server.
Is there any way or tool top use it.?
I have create project for one database SQL files of all objects for database versioning integreate with VSS.
Please needful to me..
November 20, 2008 at 3:49 am
Paresh Prajapati (11/18/2008)
I have to implement SQL Database version control..I have Micosoft visual source safe 6.0 and also have Redgate SQL Compare Pro edition...
But i don't know how to configure for SQL Database???
Please needful to me..
for versionin of database. you can perform the following
at the launch of every new version of the application, create a backup of the dB from the production sever[if possible], and create the database scripts upto that stage.
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 20, 2008 at 10:11 pm
November 20, 2008 at 10:18 pm
Paresh Prajapati (11/20/2008)
I have configure SQL Redgate ChangeSet with micosoft VSS..is it ok?
i have heard about it that this is useful. but in my case , i prepare a set that includes the following based on the version
Version 1.0 Set
Application + dB backup[Production] + dB scripts + Release note + Configuration
and same i follow at the time of every release
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 21, 2008 at 2:09 am
yes, i have used for realse..
and also i have require to track alll changes done by user and which one has done it, aslo compare and rollback with previous version of objects.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply