Continuous repliation between on-premises SQL and Azure SQL

MS Techie 2,676 Reputation points
2021-02-22T09:40:17.58+00:00

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

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-03-03T09:51:57.24+00:00

    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

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2021-02-22T09:55:49.627+00:00

    Hey @MS Techie ,
    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)

    1 person found this answer helpful.
    0 comments
  2. Vaibhav Chaudhari 38,576 Reputation points
    2021-02-22T10:01:36.877+00:00

    You can read about SQL Data sync here - https://learn.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://learn.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

    0 comments
  3. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-02-23T02:52:13.073+00:00

    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.