Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Versioning Expand / Collapse
Author
Message
Posted Thursday, November 22, 2007 4:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:46 AM
Points: 25, Visits: 268
i wants maintain different versions of my database ie (SP, tables etc)

How can i do that ?

Post #424921
Posted Thursday, November 22, 2007 6:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
zafar (11/22/2007)
i wants maintain different versions of my database ie (SP, tables etc)

How can i do that ?



You could script your database and keep the script files in source control. This can be automated with SMO, but it may become tedious when it comes to seeing the differences between your different versions.

You could also look at third party tools like:

Microsoft Visual Studio Team System for Database Professionals,
Red Gate's SQL Compare Professional
DBGhost

These allow you to use source control with your database objects.

Disclaimer: I work for Red Gate.

Regards,
Andras




Andras Belokosztolszki, MCPD, PhD
GoldenGate Software
Post #424952
Posted Thursday, November 22, 2007 7:02 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 7:16 AM
Points: 3,931, Visits: 1,102
using Visual Source Safe.

check the following link

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1093178,00.html



Post #424986
Posted Monday, March 14, 2011 1:46 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 4:48 PM
Points: 485, Visits: 1,373
http://www.sqlservercentral.com/scripts/DDL/72638/
Post #1077575
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse