x

Using the Cloud

Scenario:

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?

Thank you!!!

more ▼

asked Sep 16, 2011 at 01:00 PM in Default

avatar image

jnorris32
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

There are also 3rd party tools coming online that do some data transfer - Red Gate have a version of SQL Data Compare that works into the cloud - http://red-gate.com

more ▼

answered Sep 16, 2011 at 02:47 PM

avatar image

Fatherjack ♦♦
43.7k 79 98 117

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Sep 16, 2011 at 01:09 PM

avatar image

KenJ
24.8k 3 10 19

(comments are locked)
10|1200 characters needed characters left

You can use Red Gate tools to do exactly that. Also, MS has a new import/export mechanism that will help you out.

more ▼

answered Sep 19, 2011 at 04:57 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left
more ▼

answered Sep 21, 2011 at 10:18 AM

avatar image

Håkan Winther
16.5k 37 45 57

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2091
x1014
x279
x95
x22

asked: Sep 16, 2011 at 01:00 PM

Seen: 1131 times

Last Updated: Sep 16, 2011 at 01:00 PM

Copyright 2016 Redgate Software. Privacy Policy