asked
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!!!
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][1] [1]:
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
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
You can use Red Gate tools to do exactly that. Also, MS has a new [import/export][1] mechanism that will help you out. [1]:
http://www.google.com/url?sa=t&source=web&cd=2&ved=0CD8QFjAB&url=http%3A%2F%2Fwww.sqlazurelabs.com%2FImportExport.aspx&ei=Kyx3TseHFNCwhQeT6bjNDA&usg=AFQjCNHl5J8kUfdsZGAgfOCgjSwQGk2ehw&sig2=nPl0TCK0WYk68UrQOy1Ouw
Microsoft have a ctp for SQL azure data sync [
http://www.microsoft.com/showcase/en/us/details/bdf8abf1-2d4d-4e15-9192-107965b8432d][1] [1]:
http://www.microsoft.com/showcase/en/us/details/bdf8abf1-2d4d-4e15-9192-107965b8432d
The essence of this question is to sync data from different servers all in one place. You can use apps and tools that can help you sync all that different cloud data and databases, both external and internal.
Users have posted on different forums about copying and pasting, sharing folders over networks, Robocopy, or DFS, but these methods are less than ideal. Currently, three manual methods work, but they cannot be used when there are many files or folders. Uploading a lot of files can make the sync process take a long time. Also, users unfamiliar with Robocopy find it difficult to understand the parameters to use and how to copy files.
Otherwise, the best way to do this is to leave the burden on an IT-managed service that provides data management assistance. VLink is a wonderful platform that will do all your data-related work and provide assistance in no time. The team of experts there will sync all the data from different resources without hassle.
1 Person is following this question.
