Version Control - Migrating Objects to Production

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Version Control - Migrating Objects to...

Version Control - Migrating Objects to Production

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Saturday, November 10, 2001 12:00 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:28 AM
Points: 31,410, Visits: 13,727

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

philcart

Posted Wednesday, December 12, 2001 5:38 PM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:53 AM
Points: 2,692, Visits: 1,074

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

Group: General Forum Members
Last Login: Tuesday, May 04, 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

Steve Jones - SSC Editor

Posted Friday, December 14, 2001 9:56 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:28 AM
Points: 31,410, Visits: 13,727

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

Kris-420132

Posted Wednesday, December 02, 2009 9:37 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 35, Visits: 173

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 »

Permissions