Replications idea

[gini]

Hello.

I have pice of work to do : replication four tables between
two databases (on demand). One databases is located in main departament
anothers are on mobile-workers computers whose can work offline.
I would like using hibernate for replication:
first session read data (objects list) from "local" database,
second session save this data in main database or vice versa.
What do you think about using hibernate for this solutions ?

Thanks in advance
gini

 

[Martin Gregorie]

Hello.

I have pice of work to do : replication four tables between
two databases (on demand). One databases is located in main departament
anothers are on mobile-workers computers whose can work offline.
I would like using hibernate for replication:
first session read data (objects list) from "local" database,
second session save this data in main database or vice versa.
What do you think about using hibernate for this solutions ?

Assuming you really mean "replicate TABLES", not "copy selected rows",
why not use a simple script and the database's load/unload utilities?

IMO if its straight-forward table replication then writing a program in
*any* language is time wasted re-inventing a wheel that already exists.

 

[gini]

Assuming you really mean "replicate TABLES", not "copy selected rows",
why not use a simple script and the database's load/unload utilities?

Sorry, I would like say "copy selected rows".

thanks
gini