Feature Request: Schema Compare To Folder

[Shawn C]

One feature that no MySQL schema compare tool has (I've only seen it SQL Server tools) is the ability to “schema compare against a folder”

I've tested a few

Summary/Use case

– This folder is under source control.

– The target folder is under SVN (or similar) control.

– I compare the database to the folder.

– The folder has subfolders for Tables, Views etc.

– The files are like dbo.SomeTable.sql or SomeSchema.SomeCode.sql

This way, you get the history of any object in the database.

(This is different to an actual deployment scripts which can be generated with SQLyog)

MySQL Workbench can do it with the model but you can't do it per object

See http://dev.mysql.com/tech-resources/articles/workbench_database_management.html

This helps getting your database objects into source control, as per these (Disclaimer: I'm gbn on StackOverflow)

http://stackoverflow.com/search?q=user%3A27535+SVN+or+Subversion+OR+fowler

I’m working with MySQL nowadays, less SQL Server, and really miss this feature.

Direct comparison to source control is also useful, but not when your source control is PerForce.

I like SQLyog, the best MySQL GUI out there. Except for this feature…

[peterlaursen]

I think that with SQLyog you may schedule a 'structure only' scheduled backup (available in Enterprise and Ultimate editions) and put the SQL file(s) exported under version control somehow using the option to generate a file per table. But it could take some scripting/programming to make it work.

But what SQL Server tool(s) are you referring to that does such thing? We willl need to see it in action if we shall comment further.

[Shawn C]

'peterlaursen' wrote:

I think that with SQLyog you may schedule a 'structure only' scheduled backup (available in Enterprise and Ultimate editions) and put the SQL file(s) exported under version control somehow using the option to generate a file per table. But it could take some scripting/programming to make it work.

But what SQL Server tool(s) are you referring to that does such thing? We willl need to see it in action if we shall comment further.

Red Gate SQL Compare, http://www.red-gate.com/products/sql-development/sql-compare/features, “Folders of SQL scripts (for source control)”

Red Gate MySQL Compare doesn't have it yet (I've asked)

But I'd prefer to use one tool only if possible

[Author]

Posts