Update Remote Databases [message #222841] |
Tue, 06 March 2007 11:42 |
jayoung
Messages: 21 Registered: October 2005 Location: USA
|
Junior Member |
|
|
I have several remote database that need to have one table updated from a master table in our main office on a nightly basis does anyone here have any ideas or suggestions on how to do this?
Jay
|
|
|
|
Re: Update Remote Databases [message #222881 is a reply to message #222845] |
Tue, 06 March 2007 17:34 |
jayoung
Messages: 21 Registered: October 2005 Location: USA
|
Junior Member |
|
|
if i use Materialized Views and changes are made to the master table say one or 2 rows change how does it send just those row updates and not the whole table? and how do you schedule these jobs or update?
Jay
|
|
|
|
|