Home » Server Options » Replication » Daily data population
Daily data population [message #75365] Mon, 12 May 2003 07:49
viv
Messages: 11
Registered: February 2003
Junior Member
Hi,
I have a daily job that populates several tables in database A with updated data from a few remote databases(B,C etc.). It's not straight copies but with some logic. The tables are cleared every time and populated with new data. It is done throw procedures and db links. Due to the volume, the job runs quite some time. And I have been experiencing various errors (snapshot too old etc.) recently as data grows. Because of the dependence between tables, fail to populate one table will cause the data intact to be broken.

I was wonder are there alternatives that can handle this better. The most important is to keep data intact and efficiency is a big help too. I am thinking of creating temporary tables in database A to receive the updated data. If all the temporary tables are populated correctly, move the data to the actual tables.

Your suggestions are appreciated and thanks in advance.
Previous Topic: Replication/Backup- urgent pls
Next Topic: How to replicate the database
Goto Forum:
  


Current Time: Tue Sep 21 01:25:14 CDT 2021