Merge 2 Db's

  • Thread starter Thread starter stef569
  • Start date Start date
S

stef569

Hi,

I'm a bit lost in the 'Importing / Linking / Replication' world

What I want to do seems very easy:

I have 2 db's, on 2 different locations with exact the same db, not connected
to any network
db is not split.

db 1 enters travels + details (multiple tables +-20)
db 2 enters the incomes for the travels (only 1 table:Invoices)

When they meet the following happens:
db 1 is loaded on a usb drive

db 2 imports: all new travels, changed travels, new details, changed details
from db1
and
db 2 exports: all new Invoices

according to:
http://www.accessmonster.com/Uwe/Fo...on/2237/Replication-over-the-internet-ftp-vpn
can I not use replication because i use an usb drive to connect the db's.

I'm currently working with linked tables in db2 and Inserting, updating from
there. But I have problems finding out if a row has been changed and I realy
don't want to create something that already is avaible

What i realy need is syncronization between 2 tables and syncronization
between 2 db's except this one table...

What strategy would you advise, as I said at the start I'm a bit lost ;)

Thanks Stef
 
stef569 said:
Hi,

I'm a bit lost in the 'Importing / Linking / Replication' world

What I want to do seems very easy:

I have 2 db's, on 2 different locations with exact the same db, not connected
to any network
db is not split.

db 1 enters travels + details (multiple tables +-20)
db 2 enters the incomes for the travels (only 1 table:Invoices)

When they meet the following happens:
db 1 is loaded on a usb drive

db 2 imports: all new travels, changed travels, new details, changed details
from db1
and
db 2 exports: all new Invoices

according to:
http://www.accessmonster.com/Uwe/Fo...on/2237/Replication-over-the-internet-ftp-vpn
can I not use replication because i use an usb drive to connect the db's.

I'm currently working with linked tables in db2 and Inserting, updating from
there. But I have problems finding out if a row has been changed and I realy
don't want to create something that already is avaible

What i realy need is syncronization between 2 tables and syncronization
between 2 db's except this one table...

What strategy would you advise, as I said at the start I'm a bit lost ;)

Thanks Stef
Click to expand...

I now understand that I can't use a usb to walk around with the replica's. So
I should forget the replica idee because my db's are not direct connected in
any way?
I should create an extra field when a row is edited for all my tables and
work from there?
 
Are the two computers on a network so they can share folders?
If there is no network, are they close enough physically they could be set
up on a peer to peer network?

If either case is true, split the databases (always should be anyway),
problem solved.

If the computers cannot be connected, One idea would be to create an
additional database that would have a "transaction table". That is, write
all you updates to this table in one databae, then move it to the other
computer and have a routine that reads the table and applies the updates.
I would not recommend this method, it is only a suggestion for a last ditch
effort.
 
Klatuu said:
Are the two computers on a network so they can share folders?
If there is no network, are they close enough physically they could be set
up on a peer to peer network?

If either case is true, split the databases (always should be anyway),
problem solved.

If the computers cannot be connected, One idea would be to create an
additional database that would have a "transaction table". That is, write
all you updates to this table in one databae, then move it to the other
computer and have a routine that reads the table and applies the updates.
I would not recommend this method, it is only a suggestion for a last ditch
effort.[quoted text clipped - 37 lines]
I should create an extra field when a row is edited for all my tables and
work from there?
Click to expand...
Click to expand...

ok, i will add you option to the list, I was more feeling for the one field
that i would add.
I realy can't believe that there is no easy solution for this.
sync method for 2 tables? :)
 
Back
Top