SQL Database version control

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Blogs QotD Books SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL Database version control

SQL Database version control

Rate Topic

Display Mode

Topic Options

Author

Message

Paresh Prajapati

Posted Tuesday, November 18, 2008 11:23 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304, Visits: 390

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..

Thanks & Regards,
Paresh Prajapati

+919924626601
prajapati.paresh@yahoo.com

Post #604897

Mike John

Posted Wednesday, November 19, 2008 1:10 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:57 AM
Points: 1,420, Visits: 856

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

Post #604938

Jerry Hung

Posted Wednesday, November 19, 2008 8:27 AM

Right there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 10:59 AM
Points: 738, Visits: 865

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
http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=knowledgebase\SQL_Compare\KB200712000206.htm

I believe to integrate SQL Compare with Version Control software, you may need the Changeset software

www.SQLServerNewbie.com

MCITP: Database Administrator SQL Server 2005

Post #605191

Paresh Prajapati

Posted Wednesday, November 19, 2008 9:52 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304, Visits: 390

But also i have redgate changeset but how i can configure?

Thanks & Regards,
Paresh Prajapati

+919924626601
prajapati.paresh@yahoo.com

Post #605567

Paresh Prajapati

Posted Thursday, November 20, 2008 3:43 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304, Visits: 390

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..

Thanks & Regards,
Paresh Prajapati

+919924626601
prajapati.paresh@yahoo.com

Post #605678

krayknot

Posted Thursday, November 20, 2008 3:49 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, June 18, 2009 4:41 AM
Points: 321, Visits: 441

Paresh Prajapati (11/18/2008)

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
Senior Software Engineer
Pune.

krayknot@yahoo.com

Post #605681

Paresh Prajapati

Posted Thursday, November 20, 2008 10:11 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304, Visits: 390

I have configure SQL Redgate ChangeSet with micosoft VSS..
is it ok?

Thanks & Regards,
Paresh Prajapati

+919924626601
prajapati.paresh@yahoo.com

Post #606291

krayknot

Posted Thursday, November 20, 2008 10:18 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, June 18, 2009 4:41 AM
Points: 321, Visits: 441

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
Senior Software Engineer
Pune.

krayknot@yahoo.com

Post #606293

Paresh Prajapati

Posted Friday, November 21, 2008 2:09 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304, Visits: 390

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.

Thanks & Regards,
Paresh Prajapati

+919924626601
prajapati.paresh@yahoo.com

Post #606363

« Prev Topic | Next Topic »

Permissions