Version Control - Migrating Objects to Production
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
-
Good series of articles so far. Awaiting the final article on rolling back changes. Have had a few nightmares to sort out in that department.
Have you heard/used a product called Change Manager from Embarcadero? Found it a good tool to track changes and generate implementation scripts.
It captures differences between databases, or a previously captured archive. Then it generates all the DDL required to migrate the changes. The final scripts need a little bit of work before they are error free, but it eliminates a lot of the grunt work
Phill
--------------------
Colt 45 - the original point and click interface
-
Great Article! Currently I use a spread sheet and a naming convention on SQL Scripts to track changes to Prod, but I like the use of VSS that you have implemented. With my prod systems growing like wild fires, this will ease my pain!
-jg-
-JG -
jgee, thanks and please feel free to use it. I'd be interested to see if it works.
phillcart - I looked at Change Manager a couple years ago at PASS and talked with their developers. It was missing a few features I wanted, but it looked good. During the last couple years, I've been in the startup area and we've managed our money pretty well, so my tools budget has been loooooowwwwwwwww. I'd like to take a look and may give Embarkadero a call to see if they are interested in sending a copy. I liked their products, but there were some little issues that made it a pain for me.
Steve Jones
-
I liked the article, but I tried the links to go back to part 1 & 2 and neither of them worked
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply