I'd be tempted to use a small SQL Azure database and configure a data sync group. That way, both of your servers can reach out to a common place and don't need to be able to hit each other directly.
Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of ifum...@gmail.com Sent: Friday, 3 August 2012 8:47 PM To: 'ozDotNet' Subject: RE: One one way sync from sql to sql thru webservice? Sorry been out of office all week, wish to about 1000 thousand records a day one way. From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low (GregLow.com) Sent: Thursday, 2 August 2012 4:16 PM To: 'ozDotNet' Subject: RE: One one way sync from sql to sql thru webservice? How much data is involved? Is it a one-off or a regular thing? Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tom Rutter Sent: Thursday, 2 August 2012 3:44 PM To: ozDotNet Subject: Re: One one way sync from sql to sql thru webservice? one way would be to do a filedump on one end then load it in on the other On Wed, Aug 1, 2012 at 5:15 PM, Anthony Mayan <ifum...@gmail.com> wrote: Hoping someone can help, we have an internal database at ur office which we need to export to a website database. What is the best way to do this? There is no direct link from office db to website db. We only need to do a one way synch(Office to website db) We currently have a application at office that that connects to the server through a webservice, but how would we handler thousands of records. Anthony