I have 1 server in the cloud.
I have 5 other private servers from around the world I want to individually connect to my server in the cloud to transfer data back and forth. /////////// Is this possible? And if so, how difficult? And how am I to do it?
asked Sep 16, 2011 at 01:00 PM in Default
Each remote server can connect to your Azure instance with SSIS.
Here is a tutorial on connecting to SQL Azure from an SSIS package - http://beyondrelational.com/blogs/parasdoshi/archive/2011/07/18/how-to-use-sql-server-integration-services-ssis-to-migrate-data-from-sql-server-to-sql-azure-lt-lt-paras-doshi.aspx
answered Sep 16, 2011 at 01:09 PM
Microsoft have a ctp for SQL azure data sync
answered Sep 21, 2011 at 10:18 AM