SubSonic, a dead-simple code-generator / ActiveRecord ORM tool, is about to release a kick-ass new feature. Migrations are an awesome tool that exists in Rails, but we haven't had a solid .NET equivalent yet. I hope that SubSonic Migrations will live up to the hype.
I've
blogged about the need for this before. I've been wanting to use VSTS DB Pro in this way, but the tool just isn't meant to provide evolutionary db support.
My current project relies on SubSonic for the code-generation, but our database development is done through DB Pro. I think this is a great tool, but I fear that it's really missing something. I'm sure the next version will be much better, as is generally true with Microsoft products. 1st versions often take some time to meld, get some good feedback from the general public, and get the usage stories streamlined.
I may be able to take advantage of Migrations, however the DB Project needs to contain all scripts (and they have to be named according to the client's standards). I wonder if I could create the migrations, execute them, then use sonic.exe to generate the scripts that represent the changes. I could dump this script in the database project (or import it).
Right now it seems like a
Rube-Goldbergian mess. Any thoughts, ideas, suggestions?