Hi Team,
Could you please provide me with answers of below -
Using Microsoft Data Migration Assistant tool, what is maximum number of tables that could be migrated (with data) between on-premises SQL Server db to Azure SQL db?
Are there any limitations/disadvantages of using Microsoft Data Migration Assistant as above?
What are the limitations of Azure Data sync service when migrating/syncing data from on-premises SQL Server db to Azure SQL Server db?
What is the maximum number of tables whose data (as in #3), could be synced from on-premises SQL Server db to Azure SQL db using Azure data sync service?
Using Azure data factory while incrementally loading data between on-premises SQL Server db to Azure SQL db (as given in https://docs.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-multiple-tables-portal),
what are the maximum number of tables whose data from on-premises SQL Server db could be loaded to Azure SQL db? Apart from the limitations of this approach as mentioned in above link, what other limitations this approach has (or Azure Data factory has)?
A link for answer of each of above questions would be really helpful.
Thanks,
Salil