August 14, 2002 at 3:13 am
We have a database which is under
constant development in our lab environment.
We have multiple production environments which
are running different version of our database.
Currently production database version updates
are done manually.
Is there a tool for tracking database
changes (new table, new sp, modify table, etc)
and managing different versions of databases
for SQL Server 2000?
All ideas and comments on database version
management are greatly appreciated!
--
Lauri Hölttä, lauri.holtta@anilinker.com
August 14, 2002 at 10:12 am
I built my own (/columnists/sjones/vcspart1.asp).
There are products from Embarkadero, CA, etc. that can help. Search the forums for version control.
Steve Jones
August 14, 2002 at 11:27 am
SQL Compare won't track changes, but it'll do the scripting and show you the differences. It can then script to get 'em in sync. This is great to handle differences.
Here's the web site: http://ww.red-gate.com/
I will say that as far as tracking changes, we do something similar to what Steve has documented in his article. SQL Compare will help you get databases back in sync, but it will not do change control.
K. Brian Kelley
http://www.truthsolutions.com/
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply