Re: [SQL] Home-brewed table syncronization

2003-07-09 Thread Raj Mathur
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > "Michael" == Michael A Nachbaur writes: Michael> On Wednesday 09 July 2003 02:28 pm, Cliff Wells wrote: >> On Wed, 2003-07-09 at 14:14, Michael A Nachbaur wrote: > So, >> I'm looking at syncronizing 4 tables from one master database

Re: [SQL] Home-brewed table syncronization

2003-07-09 Thread Jason Earl
Michael A Nachbaur <[EMAIL PROTECTED]> writes: > On Wednesday 09 July 2003 02:28 pm, Cliff Wells wrote: >> On Wed, 2003-07-09 at 14:14, Michael A Nachbaur wrote: >> > So, I'm looking at syncronizing 4 tables from one master database to >> > several child databases. I'm thinking of doing the follow

Re: [SQL] Home-brewed table syncronization

2003-07-09 Thread Michael A Nachbaur
On Wednesday 09 July 2003 02:28 pm, Cliff Wells wrote: > On Wed, 2003-07-09 at 14:14, Michael A Nachbaur wrote: > > So, I'm looking at syncronizing 4 tables from one master database to > > several child databases. I'm thinking of doing the following with > > DBD::Multiplex: > > > > DELETE FROM Tabl

Re: [SQL] Home-brewed table syncronization

2003-07-09 Thread Cliff Wells
On Wed, 2003-07-09 at 14:14, Michael A Nachbaur wrote: > So, I'm looking at syncronizing 4 tables from one master database to several > child databases. I'm thinking of doing the following with DBD::Multiplex: > > DELETE FROM TableA; > INSERT INTO TableA (..) VALUES (...); > > > on all the

[SQL] Home-brewed table syncronization

2003-07-09 Thread Michael A Nachbaur
Hello everyone, While I still have plans to do some more work on RServ, it is apparent to me that I need a more immediate solution. I'm not replicating my entire dataset, but rather just some "summary" tables that are maintained by stored procedures. This means RServ is an iffy proposition at