how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

5 pts.
Tags:
SQL Server 2005
SSIS
Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over internet. I was thinking of using ssis in differentail mode ...But the internet connection is very slow , so thought if I should convert my database data into an xml data before uploading ??? Please advise. thanks sahaj

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will want to reduce the amount of data that you need to transfer to the smallest amount of data possible. This way you are transferring the smallest amount of data possible. The easiest way to do this would be to query the remote system for the highest value that it has then transfer the remaining data. If you have to deal with rows that are updating you will want to query for the latest date that the values were updated on the remote system, then transfer all records which were updated since then.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following