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

[snapurano]

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.

[wisemx]

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