Transfer Data and from remote sql to and from discount.asp sql

Hi, my client wants to transfer data from their sql server to your hosting sql database and vice versa. This operation would take place in a scheduled manner and not require any user interaction what so ever.

ex: 9pm, every night we push data from your database to theirs and when that completes we push data.

Is this possible?

If not, any options are welcome to achieve this.

 

Hi,
It can be done for free by using the Express (free) version of SQL Server 2008.
Like this: http://www.dasptv.com/avc-view.aspx?videoid=17&categoryid=1

You can also use the same local SQL Server or the DASP on-line DB manager to double-check everything. i.e. any duplicate records.
All the best,
Mark