November 22, 2007 at 4:11 am
i wants maintain different versions of my database ie (SP, tables etc)
How can i do that ?
November 22, 2007 at 6:09 am
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
November 22, 2007 at 7:02 am
using Visual Source Safe.
check the following link
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1093178,00.html
March 14, 2011 at 1:46 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply