Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chava_sree
Yak Posting Veteran
56 Posts |
 Posted - 2008-07-23 : 14:12:33
|
| Is there good Way to Maintain all the Database Updates/Inserts/ New table additions .. in a file and use that file in all other servers like staging/live.thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-23 : 14:18:13
|
| We use Visual Sourcesafe for this. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-23 : 14:56:09
|
| VSS is probably one of the worst source control programs, although it might be the easiest. chava_sree, save your changes to a file and then you can connect to your difference environments by passing that file in a sqlcmd batch file.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-23 : 15:04:30
|
| Check out Sqlfarms too. |
|
|
|
|
|
|
WRITING SCRIPTS