question

JigneshSheth avatar image
JigneshSheth asked

Data Transfer between 2 SQL Servers

I have an application and backend is SQL Server in Local Server and in Cloud Server. Now I am using one application and I want to transfer all the data on certain time duration like every 1 hour. Means data should be transferred in every hour in cloud server from local server. So please advice me how to do this process? And it can be done using sql server or not? Thanking you in advance.... Jignesh
sql-serversql serverdata-transfertransfer
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
Yes, you should be able to accomplish this using SSIS. You should be able to create a package and then schedule the package to run every hour. http://www.toadworld.com/platforms/sql-server/w/wiki/10337.migrating-data-to-sql-azure-using-ssis.aspx You don't mention what version of SQL Server you are running so you might need to confirm that for your respective version. Hope that helps!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.