What's a good framework for database migration that is compatible with SQL Server?
I was messed up by ActiveRecords. So I'm looking for a migration system that can be applied to SQL Server and either run as Java application or Win32 executable. (Of course, further compatibility with other databases and host OSs is encouraged.)
In real wish there is an explicit application to change the schema with a rollback, ideally in something nicer than SQL, so it can be DB agnostic.
The glitch I found for Java based alternatives is the lack of pure support for Microsoft JDBC.
We look forward to any suggestions.
source to share
Check out Ben Sheirmans for a great post on the topic:
http://flux88.com/blog/net-database-migration-tool-roundup/
I tried Tarantino and it worked fine, but you are still locked out of sql scripts for SQL server.
/ Anders
source to share
Try Mite. I wrote it and have used it for years.
https://github.com/soitgoes/mite
If you enable "Auto Generate Change Scripts" then Sql Management Studio will generate sql which you can save to your tick file. No more writing to let Management Studio do it for you! Then if you ever need to customize some application to modify data, you can simply do it in sql and save it for migration.
Let me know what you think.
source to share