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.
May 30, 2008 4:56 AM
May 30, 2008 8:56 PM