Can Azure Migrate be used similarly to Flyway for schema migration?

Question

Our team's application is in early development and will be using our application for usage/testing purposes. There'll be changes in our SQL schema that will require dealing with schema migrations.

While I know that Liquidbase and Flyway are good tools for schema migration, does Azure migrate allow for similar functionality between schema versions on the same database? Or is it only reserved for migrate from one database engine to another?

question from:https://stackoverflow.com/questions/66057391/can-azure-migrate-be-used-similarly-to-flyway-for-schema-migration

Answer 1

Yes, Azure migrate support the database and the schema migration:

• Databases: Assess on-premises databases and migrate them to Azure SQL Database or to SQL Managed Instance.

But I think you also could look at Data Migration Assistant. If your database is not very large and that's a better tools. It supports schema migration between same Server/database.

Ref this example: https://www.mssqltips.com/sqlservertip/5455/using-the-data-migration-assistant-dma-tool-to-migrate-from-sql-server-to-azure-sql-database/#:~:text=Using%20the%20Data%20Migration%20Assistant%20%28DMA%29%20tool%20to,the%20Azure%20SQL%20database.%20...%20More%20items...%20

Per my experience about Azure, there isn't a way to sync the schema. Azure migrate or DMA or DMS more focus on the schema/database migration, both can not meet your request.

HTH.