Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Replication to/from Azure SQL Database Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2014 7:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:26 AM
Points: 100, Visits: 467
I can't find any other posts on this subject so I thought I would start one as a placeholder and float some ideas.

I understand that proprietary SQL Server Replication is not possible to/from Azure SQL Database due to obvious reasons (no local MSDB DB or SQL Agent for example).

My best solution so far is for an intermediary SQL Server sitting inside an on-premise DMZ to move data in and out using SSIS Packages. This solution relies upon 'duplicate' licensing which almost makes the cloud-concept academic however, plus at least a working knowledge of SSIS.

Alternatively an Azure SQL Server VM (Iaas) with the necessary VPN configured to connect to on-premise servers using Domain credentials. Again, this negates the WASD (PaaS) concept.
Post #1592543
Posted Tuesday, July 15, 2014 9:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:26 AM
Points: 100, Visits: 467
...is there any news on SQL Data Sync? I can find old postings on TechNet and MSDN but cannot see any sign of that functionality within the Portal. I guess another feature retired before it lived?
Post #1592658
Posted Tuesday, July 15, 2014 10:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 13,890, Visits: 28,285
The only way I know of that you could currently do this would be to build it yourself. Whether you use SSIS or not is something of a discussion point, but it'll have to be an external application because there's nothing within the direct Microsoft Azure SQL Database stack to support it.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1592671
Posted Tuesday, July 15, 2014 7:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:11 AM
Points: 213, Visits: 855
SQL Swerver (7/15/2014)
...is there any news on SQL Data Sync? I can find old postings on TechNet and MSDN but cannot see any sign of that functionality within the Portal. I guess another feature retired before it lived?


It's called Sync Framework now. I tried to use it instead of replication for some local servers and if you do the same on anything more than the barest quantity of data you're going to have an extremely bad time. It's really designed for synchronising tiny amounts of data to mobile/tablet clients and it's quite a pain to work with (I was using PowerShell).
Post #1592874
Posted Wednesday, July 16, 2014 4:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:26 AM
Points: 100, Visits: 467
Good call, thanks Cody K for the insight!
Post #1592986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse