Connecting to on-premises SQL Server through Azure Service Bus

Question

Is this possible through some tcp redirection? If so, how?

Edit: I'd like to connect to on-premises SQL from a worker role to do some custom ATS-SQL synchronization.

I need to sync-up some data with the on-premise SQL server and do not want for this stuff to run on premise due to hardware constraints. I'm also weary of Azure Connect because it is not yet released — Igorek
– Igorek, Commented Dec 21, 2011 at 2:07

Sameer · Accepted Answer · 2012-01-04 06:03:52Z

2

You can try out the new Service Bus EAI & EDI Labs Release. It provides connectivity to various on-premise systems including SQL Server. The connectivity is provided using Service Bus Relay, and may be exactly what you are asking for. In the process, we can do transformations of the data on the cloud etc.

It is not in production yet, but we would like to get feedback on this. http://blogs.msdn.com/b/windowsazure/archive/2011/12/16/announcing-the-service-bus-eai-amp-edi-labs-release.aspx

Thanks, Sameer [MSFT] sameerch @ microsft.com

answered Jan 4, 2012 at 6:03

Sameer

211 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Mitch Wheat · Accepted Answer · 2011-12-21 02:09:15Z

0

Have you looked at the Sync Framework to synchronise your data?

Sync Framework: SQL Server to SQL Azure Synchronization

answered Dec 21, 2011 at 2:09

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

2 Comments

Igorek Over a year ago

I have. Unfortunately, I am not syncing with SQL to SQL.. but am syncing with SQL to ATS

Mitch Wheat Over a year ago

Perhaps make that more explicit in your question.

Chris J.T. Auld · Accepted Answer · 2011-12-21 05:01:16Z

0

Much as I love the idea of routing raw TCP traffic through the service bus the performance is going to be pants (sorry Clemens...)

Have you taken a look at WIndows Azure COnnect http://www.windowsazure.com/en-us/home/tour/virtual-network/

This will basically give you a VPN like connection back to your on-premise SQL Server. If you can make it work (i.e. can install the agent locally) then this is probably the best approach.

answered Dec 21, 2011 at 5:01

Chris J.T. Auld

9864 silver badges8 bronze badges

Comments

Yossi Dahan · Accepted Answer · 2011-12-22 11:29:48Z

0

If all you need is data sync, have you looked at SQL Azure data sync?

http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-data-sync-overview.aspx

answered Dec 22, 2011 at 11:29

Yossi Dahan

5,3792 gold badges30 silver badges50 bronze badges

1 Comment

Igorek Over a year ago

SQL Azure data sync only syncs SQL-based to SQL-based afaik. I need to sync ATS to SQL

Collectives™ on Stack Overflow

Connecting to on-premises SQL Server through Azure Service Bus

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related