Menu
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.
515
There are three main approaches to database migration: big bang data migration, trickle data migration, and zero downtime migration.
SQL Server Migration Assistant (SSMA) Migrate Microsoft Access, DB2, MySQL, Oracle, and SAP ASE databases to SQL Server. Migrate Microsoft Access, DB2, MySQL, Oracle, and SAP ASE databases to Azure SQL.
Database migration is the process of migrating data from one or more source databases to one or more target databases by using a database migration service. When a migration is finished, the dataset in the source databases resides fully, though possibly restructured, in the target databases.
You could take a look at Wizardby (open source)
84
Perhaps Liquibase or dbdeploy meets your needs? I've also heard good things about RedGate.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
