What is a Database Migration?

What is a database migration?

It is the process of changing & upgrading the data like MySQL to MS SQL or vice versa.

It is a complex, multiphase process, which usually includes assessment, database schema conversion (if you are changing engines), script conversion, Data Migration, functional testing, performance tuning, and many other steps.

Following are the types of migrations:

·         Schema Migrations

·         Server Migrations

·         Version Migration

·         DBMS Migration

 

The steps for the Database Migration:

a)        Creating Migrations

b)        Transactional Migrations

c)        Applying Migrations

d)        Reverting Migrations

e)        Redoing Migrations

f)         Showing Migration Information

g)        Modifying Migration History

h)        Customizing Migration Command 

Also Available on Microsoft AppSource : 

Application Migration Tools

Infrastructure Assessment Tools

Azure Cost Monitoring Tools

Azure Guidance Tools