Hi All

I know this is quite an open ended question, but I am just starting to look at what solutions are available...

I have been asked to look at an effective way to automatically/ securely transfer data from SQL server instance to another SQL Server instance on a daily schedule?

Basically my client doesn't want me to create an ASP.NET2 reporting application using their live data. But rather me transfer a copy of its data to a secure location for reporting use.

Any solutions/ paths to explore would be appreciated.

Many thanks,

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

You can use any of the following -
* take full backup of database once and then differential backup on scheduled basis.
* use of DTS package and time to time executing it ..
* use replication
or * just detach your database and then manually copy the file (not a good method) ..



I have known a great many troubles, but most of them never happened. -- Mark Twain

Thanks, thats great Manudutt.

With DTS is there a way to schedule it to transfer daily?

Rit

You can also create a stored procedure to do a full backup and restore if you don't like or know DTS.

yes , you can schedule a DTS package to run on time , just rightclick on the package and choose 'Schedule Package ...' . Then set a schedule . This way you can schedule it .

Out of the solutions above which would you consider being the most secure as this data is effectively being transferred accross the net. One server to another...

ta

Rit

Safe way to xfer over the net,
1) backup to local server
2) encrypt the data
3) transmit the data
4) decrypt the data
5) then restore the data.

DON'T trust DTS security!!!

Because there isn't going over the web.