Generate initial database migration script from existing schema

Question

I have a huge pre-existing database that I'd like to bring under version control using Migrator.NET for migration scripts and I don't like keeping the MDF file around just for the existing schema.

How can I generate an initial migration script (Migration class) for Migrator.NET from the existing schema that I can use to build the schema from scratch and use incremental builds onwards?

Fergus Bown · Accepted Answer · 2011-06-07 15:05:40Z

1

According to this link http://code.google.com/p/migratordotnet/wiki/WritingMigrations you can do this:

Migrator.Console.exe SqlServer "Server=localhost\SQLEXPRESS;Database=DB;Trusted_Connection?=True" MyMigrations.dll -dump "c:\temp\dump.cs"

answered Jun 7, 2011 at 15:05

Fergus Bown

1,6969 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generate initial database migration script from existing schema

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related