Table Replication and Synchronization in AZURE

Question

I am pretty new to AZURE cloud and stuck at a place where I want to repplicate 1 table into another database with same schema and table name.

By replication I mean, the new table in another database should automatically synced with the original table. I can do this using the elastic table, but the queries are taking way too long and some time getting timed out, so I am thinking of having a local table in another database instead of elastic table, but I am not sure how I can do this in AZURE ? Note: Both database resided on same DB server

Any example, links will be helpful

Thanks

score 0 · Answer 1 · answered Aug 01 '18 at 08:45

0

To achieve this you can use a DACPAC (Data-Tier Package) a data tier package can be created in Visual Studio or extracted from an existing database. They contain the database creation scripts and manage your deltas for you. More information can be found here. For information about how to build and deploy a DACPAC using both VS and extracted from a database see this answer

answered Aug 01 '18 at 08:45

Pete Philters

869
5
12

Thanks! But i have to keep the destination table in sync with source table all the time. – D Deshmane Aug 01 '18 at 09:57
When you say the _elastic table_ do you mean elastic database query as mentioned [here](https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/) – Pete Philters Aug 01 '18 at 10:00
Yes, that is the one – D Deshmane Aug 01 '18 at 10:01
Ok, I'm not sure of another way, without using external tooling which seems excessive for the task. Sorry I couldn't help this time – Pete Philters Aug 01 '18 at 10:02
There is a way out in azure, refer https://learn.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync. But I am not able to configure this 1 :( – D Deshmane Aug 01 '18 at 10:04
How are you unable to configure? – Pete Philters Aug 01 '18 at 10:05
I did it, but the data is not flowing to destination table. Am Trying it hard :) – D Deshmane Aug 01 '18 at 10:08

Table Replication and Synchronization in AZURE

1 Answers1