question

AzureUser-9588 avatar image
0 Votes"
AzureUser-9588 asked rajpo answered

On prem SQL server database with multiple filegroups, migration to Azure SQL Database.

I have an on-premise SQL database with multiple filegroups, can I migrate it to Azure SQL Database (not to a Managed instance).
If No, what are the possible workarounds to complete the migration to Azure with/without downtime?
If Yes, is it possible to do the migration without any downtime?

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KalyanChanumolu-MSFT avatar image
1 Vote"
KalyanChanumolu-MSFT answered

@AzureUser-9588 Thank you for reaching out.

You can choose between an offline migration (with downtime) and an online migration (minimal downtime during the actual cutover)
All the tooling and documentation required for migration is here

Coming to your question on filegroups, it is not possible to create filegroups on Azure SQL Database. However, the migration tools take care of this scenario.
All references to filegroups other than Primary on the source database are automatically replaced with references to the PRIMARY filegroup when SqlPackage imports a .bacpac file.


Please let us know if you face any issues.



If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

rajpo avatar image
1 Vote"
rajpo answered

Having multiple file groups on your source database is not a blocker for Azure SQL DB Migrations, you can migrate the data using logical methods used in Azure Database Migration Service (DMS).
1. At first you use Data Migration assistant (DMA) tool to perform schema migration.
2. Use DMS service performing the data migration.

Here are the steps.
Thanks
Raj


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.