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

Version Control - Migrating Objects to Production Expand / Collapse
Author
Message
Posted Saturday, November 10, 2001 12:00 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:38 PM
Points: 31,368, Visits: 15,834
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1603
Posted Wednesday, December 12, 2001 5:38 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 15, 2014 7:14 PM
Points: 2,693, Visits: 1,223
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



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #23740
Posted Friday, December 14, 2001 9:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 4, 2010 9:59 AM
Points: 137, Visits: 14
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
Post #23741
Posted Friday, December 14, 2001 9:56 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:38 PM
Points: 31,368, Visits: 15,834
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
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #23742
Posted Wednesday, December 2, 2009 9:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:08 PM
Points: 35, Visits: 176
I liked the article, but I tried the links to go back to part 1 & 2 and neither of them worked
Post #827633
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse