Azure data factory data tranfer without control table/watermark table or datetime

Question

Hello All,

I want to be able to transfer data from SQL source DB to destination DB(Azure), but i do not have a datetime column, how do i achieve this?

Please do help if you have any solution.

thanks

Answer 1

Hello @john azcn ,

Welcome to the MS Q&A platform.

Please correct me if my understanding is wrong. You want to migrate data from the on-prem server to Azure SQL DB.

You can use ADF's copy activity to migrate the data to your Azure SQL. (Or) you can also use the DMS service.

You can refer to the below documents to get started with your migration.

https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql
https://learn.microsoft.com/en-us/azure/architecture/data-science-process/move-sql-azure-adf
https://www.sqlshack.com/migrate-an-on-premises-sql-server-database-to-the-azure-sql-database/

Please let me know if you have any further questions.