Art
Art

Reputation: 24567

Database migrations for SQL Server

I need a database migration framework for SQL Server, capable of managing both schema changes and data migrations.

I guess I am looking for something similar to django's South framework here.

Given the fact that South is tightly coupled with django's ORM, and the fact that there's so many ORMs for SQL Server I guess having just a generic migration framework, enabling you to write and execute in controlled and sequential manner SQL data/schema change scripts should be sufficient.

Upvotes: 6

Views: 5414

Answers (3)

David Atkinson
David Atkinson

Reputation: 5899

Redgate's migrations solution in Visual Studio is ReadyRoll.

Our SSMS-based solution is SQL Source Control.

Upvotes: 1

Ed Harper
Ed Harper

Reputation: 21505

You could take a look at Wizardby (open source)

Upvotes: 2

ig0774
ig0774

Reputation: 41247

Perhaps Liquibase or dbdeploy meets your needs? I've also heard good things about RedGate.

Upvotes: 2

Related Questions