http://schematodoc.com/ http://www.ombelt.com/exportschema/sql/mssql/index.html?AdwExportSchemaSQL Not sure if they are commandline tools though.
_____ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Tuesday, 17 April 2007 12:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Version Controlling a Database Steve, Cheers will read it tomorrow, but I need something that is not Db dependant though. On 4/17/07, Steve Onnis <[EMAIL PROTECTED]> wrote: Andrew Have read the whole lot but this seems to be what you are wanting to do http://msdn.microsoft.com/msdnmag/issues/03/05/MetaDataServices/ _____ From: cfaussie@googlegroups.com [mailto: <mailto:cfaussie@googlegroups.com> [EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Monday, 16 April 2007 11:37 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Version Controlling a Database Ok, Now it seems that everyone is getting the wrong end of the stick here, the scenario is going to be simple. This is for development only, and we are in the middle of a huge project with many developers working away, we have already introduced TDD with XP Agile development and have everyone using SVN for creating different versions. But the problem now is the database, if we need to support n versions of an application we are finding that the database requires more work and maintenance than it really should when switching between different branches of our code. So as someone mentioned I would not be looking for a solution for production, come on guys I have been developing long enough to not make a stupid move like that. The problem is that we currently use RedGate as I said earlier and its works well for MS SQL Server, but it doesn't work for mySQL or Oracle or DB2. Now if you look at having to switch to a different branch of code to maintain, there really needs to be someway to do this with SQL schemas as well. And yes we have daily backups, but this is not the issue. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---