question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked ·

Continuous repliation between on-premises SQL and Azure SQL


I have on-premises SQL Server 2014 database , which i want to replicate to Azure SQL .

Is it possible to continuously replicate to Azure SQL (real-time replication ) ?

i want to replicate only a few tables, in my database.

Please help

sql-server-generalazure-sql-database
· 1
10 |1000 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.

Hi MSTechie-7364,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ·

Hi MSTechie-7364,

difference between SQL Replication and SQL DataSync.

73745-01.jpg

in case of DataSync , what is used ?

You can install and configure the Data Sync Agent for SQL Data Sync to sync data with SQL Server databases.
Please refer to Data Sync Agent for SQL Data Sync and the tutorial which might help.
Best Regards,
Amelia



01.jpg (56.2 KiB)
·
10 |1000 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.

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered ·

Hey @MSTechie-7364 ,
You can use the concept of Data sync to achieve this for real time.

You can use also Azure data factory to copy by keeping a scheduled trigger (but not real time)

·
10 |1000 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.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

You can read about SQL Data sync here - https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database#when-to-use

and follow the steps given in here - https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

·
10 |1000 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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ·

Hi MSTechie-7364,

You can configure transactional replication to synchronize data from on-premises SQL Server to Azure SQL Database. You can configure the on-premises SQL Server databases that you wish to migrate as publisher and configure your Azure SQL Database as push subscriber to the SQL Server instance. Please refer to this article which might help.
In addition, transactional replication can also be used to synchronize your data from on-premises SQL Server to Azure SQL Databases in one direction. To synchronize data in bi-direction or from Azure SQL Database, you can use Azure SQL Data Sync as others have mentioned. Please refer to this tutorial which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1 ·
10 |1000 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.

Hi @AmeliaGu-msft

Thanks for the reply . What is the difference between SQL Replication and SQL DataSync. ?

For SQL replication , we will use SQL Server Agent ... but in case of DataSync , what is used ?

0 Votes 0 ·