can we merge sql server two databases to single database while migrating to Azure MI

Mani kothakota 1 Reputation point
2021-04-22T08:44:32.8+00:00

Migration project and This is requirement from client , There are On premise server and tow databases , client asking to merge two db's in single db while migrating to azure MI , is it possible and is there any option in azure services to merge two db's to on db

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
719 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,006 Reputation points
    2021-08-30T08:35:25.507+00:00

    is it possible and is there any option in azure services to merge two db's to on db

    No. The migration to Azure creates a 1:1 copy of the source database.
    You can only manually merge the database before you are going to migrate.

    0 comments