I used Tarantino for database change management on a previous project: http://code.google.com/p/tarantino/wiki/DatabaseChangeManagement . It worked pretty well in general but i prefer the idea of separating schema changes, data changes and stored procedure changes. We don't have redgate so when making changes in SqlServer, i generally just click the 'create script' button.
Another similar alternative is RoundhousE - http://code.google.com/p/roundhouse/ . I'd consider using it on future projects as its more aligned to my ideal change management system even though the name/Chuck Norris theme is a little lame. Cheers, Paul. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of silky Sent: Thursday, 10 June 2010 12:00 PM To: ozDotNet Subject: regarding db sync I know there was a thread on this recently. The versioning inside the DB is obviously one component of this, but scripting the changes is the other part. Does anyone automate the scripting? It seems to me that it would be cool if you had a command-line tool that scripted the latest changes to local DB that you were working with (i.e. configurable in some script) and then saved those changes to a file as part of a source-control commit operation. That is to say, you'd script this tool as a pre-commit operation (locally, I think most source control systems support this kind of operation). I'm pretty sure someone on this list has such a tool. I can't quite remember. Anyone taking this approach? Is it a good idea? The reason I like it is because I don't have to make the script myself (which is trivial but boring) and it means I won't miss anything. Obviously significant configuration of the tool would be appropriate (and a chance to perhaps review the script before it was committed). It would be good because it's kind of extravagent to have individually-held files for each DB item. Perhaps not. -- silky http://www.programmingbranch.com/ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ "This email is intended for the named recipient only. The information contained in this message may be confidential, or commercially sensitive. If you are not the intended recipient you must not reproduce or distribute any part of this email, disclose its contents to any other party, or take any action in reliance on it, or in reference to it. If you have received this email in error, would you please contact the sender immediately and delete/destroy all copies of this message, both electronic and otherwise. It is the recipient's duty to virus scan and otherwise test the enclosed information before using the information or loading attached files onto any computer system. Oasis Asset Management Ltd does not warrant that the information contained in this e-mail is free from viruses, defects, errors, interception or interference. Any views expressed in this message are those of the individual sender, except where that sender specifically states them to be the views of Oasis Asset Management Ltd." ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
