Linked server b/w two Azure SQL database using SQL jobs

Gyanendra Singh Rathore 1 Reputation point
2021-07-10T06:58:44.933+00:00

I have one Azure SQL server on one account, same replica is created with other account (Azure SQL DB) also.

I want to send SQL data from one account to other account frequently (Every 3 hours), but not sure how we can connect those two SQL databases. both are in same region now.

Is there any service we can use, if yes which service and at what cost? there is more cost involved while sending data from one account other account?

Azure Database Migration service
Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,736 Reputation points
    2021-07-10T08:02:17.437+00:00

    You can use Azure data factory service to create a pipeline to copy the data and schedule this pipeline. Cost will depend on how long the pipeline runs and DIU units used.

    More details here - https://azure.microsoft.com/en-in/pricing/details/data-factory/

    Another option (if you are not looking for Azure based solution and avoid ADF cost) is to create SSIS package and schedule it

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

    0 comments
  2. Alberto Morillo 33,861 Reputation points MVP
    2021-07-10T18:00:47.733+00:00

    If you would like to keep the 2 databases in sync on certain number of tables you can use Azure Data Sync. It is free. You can set "automatic sync" to On and specify sync frequency in terms of seconds, minutes, hours or days.

    0 comments
  3. Gyanendra Singh Rathore 1 Reputation point
    2021-07-10T18:40:08.17+00:00

    thanks for your support, please suggest, we are considering SQL server & frequent connectivity with two different account?

    I am bit new to this so, before proposing any solution I want something which will work without fail.

    0 comments
  4. Alberto Morillo 33,861 Reputation points MVP
    2021-07-10T21:45:10.607+00:00

    You can definitely use Azure SQL Data Sync as it can be used to sync 2 different Azure SQL Databases that belong to different subscriptions. Please read here under which conditions this is possible.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.