Best way to transfer data between servers

Question

Best way to transfer data between servers

robin-519709

SSC Enthusiast

Points: 191
More actions
May 27, 2010 at 8:00 am

#235562

We are playing with a SQL Azure database that we would like to sync with a local server. We have created a last updated time stamp column in azure that gets updated via triggers.
I would like to insert into localdb, where azuredb timestamp > max timestamp in localdb.
Azure doesn't seem to support linked servers. What is my best option for transferring these rows from azure to a local server? I would like to find a way to automate the function via a .NET app so that it can scale (Opposed to creating new tasks in a SSIS package every time I add a table)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bueyes SSC Eights! Points: 871 More actions · Answer 1

robin-519709 (5/27/2010)
We are playing with a SQL Azure database that we would like to sync with a local server. We have created a last updated time stamp column in azure that gets updated via triggers.
I would like to insert into localdb, where azuredb timestamp > max timestamp in localdb.
Azure doesn't seem to support linked servers. What is my best option for transferring these rows from azure to a local server? I would like to find a way to automate the function via a .NET app so that it can scale (Opposed to creating new tasks in a SSIS package every time I add a table)

Due to opperation characteristics of Azure is not possible make a linked server, however you can try to use a mirroring schema. Usually this can work with SQL Server servers, I don't know if Azure have some restiction about it.

Regards

robin-519709 SSC Enthusiast Points: 191 More actions · Answer 2

By "mirroring schema" do you mean SQL replication? I know that is not supported.

Bueyes SSC Eights! Points: 871 More actions · Answer 3

No, mirroring databases is a schema a litle different of Replication, but I need to review my notes.

Bueyes SSC Eights! Points: 871 More actions · Answer 4

Hi, you need review the information about sync process at http://www.microsoft.com/windowsazure/developers/sqlazure/datasync/ this microsoft site can help to sync data betwen SQL Server and SQL Azure.

I hope this can help

Regards

robin-519709 SSC Enthusiast Points: 191 More actions · Answer 5

Thanks for the suggestion, We had tried the tool out initially, but had some reliability issues with it. Most posts I've seen say it doesn't handle large amounts of data very well.