| Resant 2005-09-21, 3:23 am |
| We have 3 database, A, B & C in Server X and D in Server Y.
A contains data production 2003
B contains data production 2004
C contains current data production (2005)
D contains all data from A, B & C
A, B, C used for transaction, D used for reporting
Because we normalize the database year by year, database A, B & C have
different table structure.
And D is a database that we have denormalize to speed up the reports,
so it have different structure too.
Synchronize Method :
-> Put ModifiedDate field in every tables at Database C that will be
changed if
user modified the data
-> Used DTS & job that's executed every 2 hours to synch. data between
Database
C & D that have been modified during last 2 days based on
ModifiedDate
field.
The problems is how to synchronize current data (2005), so user are
able to see up-to-date data, because that data will changed frequently.
DTS & job method is to slow (approximate 13 sec), if user open the
report while the job's executed they will see the uncompleted report.
FYI, we use Crystal Report to provide all reports, using OLE DB
connection.
Please help me, is there any method that's better than DTS that can
refresh the data quickly? Could I use replication if database C & D
have different structure?
Thank you
|