| Update master table with changes only [message #424684] |
Mon, 05 October 2009 05:53  |
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
|
Senior Member |
|
|
Hi,
We have an ERP aplication from where we'll be getting some data in some tables to be pushed into another set of tables in a seperate database which would be used mainly for reporting.
The data would be populated in some parking tables in 24 hour intervals. There would be some transaction tables as well as Master tables.
We need to update our reporting database with the DML operations done in the ERP database via the parking tables.
For the master tables...there won't be much changes everyday...may be some additions and some updations. What is the best way to do this activity.
Regards,
Mona
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
