Forum Discussion
Migrating Microsoft SQL and website to Azure with a Workspace
haitsongI don't have to do everything at once. I just need it to work together once everything is in Azure. I have all the VMs replicated and backed up. I can upload the parts separately but will they work together?
nsbar450 Before you move, you can run the capture of the Sql queries traces and use DMA (data migration assistant) to see if it raises any issues with your queries that you used in your application. Since the version of SQL Server vs the version of the SQL Server you are moving into may have some difference in features. The DMA tool should help you to identify if there is any gap to be fixed.
DMA is also capable of moving the database for you, especially for small databases.
Once you have cleaned up any issues that DMA may raise, then you can try to look into places that your application configure to use as the connection string, and see if you can get that working by pointing to new DB in azure. So does the file shares, you can point them to azure file share in your application and verify if it works.
BTW, I am not sure if I understand the role of the "VM" in this architecture of the application, please elaborate if I missed something.
Also our database migration guide may be helpful to find some tutorials
https://datamigration.microsoft.com/