Synkronisering af 2 databaser

Kan du ikke bare hente den opdaterede??

jo men der mangler lisom nogle data som er i backupen, det er ikke mit site, og dem der har det kørte vidre i nogle dage inden de opdagede fejlen......

Det er en meget kompliceret database så det vil tage lang tid at gøre det manuelt

Altså det jeg gerne vil er at hente de data som er i backuppen over i den opdaterede database.....

Well if this was in Access then  it owuldnt be a problem, but as it is in a web program then it isnt so easy I dont think. I also assume that you can NOT take your database offline.

I think your best bet is something like this.

For each table, (one at a time) make a connection to the backup. Then loop through the recordset, for each record make a query (SQL) to see if the record exists in the existing table. If it doesnt exist then create it, if it does exist then go on to the next record in the backup table.

There is NO easy solution, it will have to be programmed.

I have both databases on my computer and both is in access....

so you can link the backup databases tables into the other database. Then make a query something like this

INSERT into MainTable SELECT * FROM BackupTable WHERE BackupTable.PrimaryKey NOT IN (SELECT M.PrimaryKey FROM MaintTable M)

ok - i vil have to do the procidure for each table ?

and maintable and backuptable is the tablenames in my db ?
and what is M ?

Yes you will need to do this for all your tables.

M is just an alias name for MaintTable.

If you are having problems then perhaps I can take a look?
eksperten@NOSPAMsanthell.dk

remove NOSPAM

status?

Found a solution :) There is a query guide that does what i need :)

You get the points for leading me 2 it :)

Thanks

Great to heár you found a solution, and thanks for the points :o)