question

GyanendraSinghRathore-9666 avatar image
0 Votes"
GyanendraSinghRathore-9666 asked AnuragSharma-MSFT commented

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

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-sql-databasesql-server-integration-servicesazure-database-migration
· 1
5 |1600 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 @GyanendraSinghRathore-9666, just wanted to check if you need any more details on this. If any answer helped, you can mark it 'Accept Answer'

0 Votes 0 ·
VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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

5 |1600 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.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered

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.



5 |1600 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.

GyanendraSinghRathore-9666 avatar image
0 Votes"
GyanendraSinghRathore-9666 answered

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.

5 |1600 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.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered

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.



5 |1600 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.