SQL Azure, data sync from SQL Azure to SQL Server

Question

I love the changes that have been made to SQL Azure since it RTM'ed. Kudos to the team.

I know how to sync from our local SQL Server to SQL Azure. What I can't figure out is how to Sync from SQL Azure back to out local SQL Server. So, how do I do this?

Thanks,

---

Owner, Quilnet Solutions

Answer 1

Hi,

I assume you are using Sync Framework to sync between your on premise SQL and SQL Azure, right? If so, you can specify the 'Direction' on the SyncOrchestrator to specify the sync is two-way. The default is 'UploadAndDownload' which means changes made in your SQL Azure database are also synced back in your on premise SQL.

Is this what you are looking for?

Edward

Answer 2

Just after I posted this I realized how stupid this question was. No, we aren't using the Sync Framework. We haven't taking the time yet to learn how to program our code with it. We have been using Generate Scripts in SSMS to get stuff to Azure, what I didn't realize is that Azure supports Generate Scripts on it's end to get the data back down to our local database. But yes, we really need to look at how to program our code to work with the Sync Framework. I know we are behind.

---

Owner, Quilnet Solutions