Scheduled database updates

Hello</o>
</o>
I would like to update my DASP SQL 2005 database with data from the SQL server on my LAN.</o>
The DASP data will be read only, i.e. no updates. I would like to update/replace the DASP data every few hours, so I need an automated process.</o>
</o>
I've used SQL snapshot replication on an internal SQL server in the past, but i don't think it is support by DASP.</o>
</o>
Not sure how to tackle this issue, any past experience, ideas or suggestions would be greatly appreciated.</o>
</o>
Mark

 

The only way to do this from your end, that I'm aware of, is with local DTS.

You can create each server in a local DTS package then run procedures from it on a schedule.

Be careful however, you will need to watch for duplicate records.
A safety net I've used for doing this with DTS is to drop some tables before a trigger or procedure is run.
You can use a temp table to hold records, drop the receiving data table, then fill her up.
That's not necessary, just a little trick for insurance.
Salute,
Mark

 

Thanks Mark

I will install and play with DTS tomorrow

Mark