Forum Discussion

Daniel Velez's avatar
Daniel Velez
Brass Contributor
Jul 09, 2023

SQL Server to Azure SQL options

Hi!

We need to have a copy of an on-premise SQL Server database in Azure SQL. The database has to be updated on a daily basis.  We tried with SQL Data Sync, but that database has more than 500 tables.  We saw the possibility of exporting the database as a BACPAC file and uploading it to Azure, but it looks like it better for migration purposes, and it wouldn't work for this case, considering we need to update the database daily.  

 

What would be a good option for what this customer needs?

 

Thanks... 

DV

2 Replies

  • DuersinKurt's avatar
    DuersinKurt
    Copper Contributor
    Jul 11, 2023

    is it a Managed Instance or a SQL-Database? If it's the first one, you could see for LRS https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate?view=azuresql&tabs=sas-token

     

    but ofc you could just mimic CDC via Azure Data Factory or SSIS, grabbing Deltas and moving them to the Data Base. But you would need to either pay for Azure Data Factory or have sufficient HW on prem for SSIS to schedule and run this task.

     

    Granted, it will be a pretty big task with 500 Tables, although handleable