How to compare two data bases and to update them

fulvio53s03 · Post by **fulvio53s03** » 2014-02-28 08:18:35

Dear friends,
I would like an help about the question in the subject.
I mean: I have 2 amc DB: the first has complete informations, the second contains the translated title, the borrower and a comment (perhaps already included in the first DB).
I would like to compare the 2 DB and extract the informations from the second to update the same movie in the first.
Do you have suggestions?
a script (help me to write it)?
any hidden/not seen option in amc's options?
I hope to have been clear.....

Thanks.

Post by **antp** » 2014-02-28 10:11:45

Maybe exporting the second one to CSV and then writing a script to parse that and import it in the first one?
Or there may be an easier way but right now I do not really have an idea.

fulvio53s03 · Post by **fulvio53s03** » 2014-02-28 12:13:08

antp wrote:Maybe exporting the second one to CSV and then writing a script to parse that and import it in the first one?
Or there may be an easier way but right now I do not really have an idea.

Thanks, I had the same idea but i'm growing old and it it's more and more difficult to resolve problems and to write scripts.....