merging databases

[Dudley]

Hi

This ought to be easy to do but I just can't see for looking!

I have several PG3 and PG2 databases that I would like to merge into one - question is how do I do it??

I have tried the manual and couldn't see anything useful there - plenty about exporting files but not importing. Is there a way of opening multiple databases and then dragging and dropping data from database to database?

[grantsonuk]

Not sure about pg3 but pg2 uses a Microsoft access database (.mdb file) on the back end unless you have the SQL version.

With the PG2 databases back up your .mdb files and import the data from one to the other

Here is the microsoft documentation on merging/importing data

https://support.office.com/en-us/article/Import-or-link-to-data-in-another-Access-database-095ab408-89c7-45b3-aac2-58036e45fcf6#bm2

Just remember, before manipulating data always back up

[Phil Hoppe]

Have you tried Transferring each of your Customers to a briefcase PAT file.
No database tools required.
you just have to make sure that the PAT file was created in PG3 if going to a PG3 database.

[southseas]

Hi Dudley

You won't be able to directly merge PG2 Databases into PG3, their structure is different. I would first merge the PG2 Databases, not being a DB guru, by doing as Phil suggests (G'day Mr Hoppe). Send each DB to a PAT File, open a new PG2 Database and import each PG2 Pat file into that.

Then open your merged PG2 Database with Patguard 3, this will turn it into a PG3 DB, send that to a Pat file (PG3 format)- merge the PG3 databases by sending them to Pat files and opening in a new DB, finally open your :merged PG2 (now a PG3) Pat file and that's it- pretty messy, and if someone can share a quicker way, great.

[Amy Lyons]

Hi Dudley

southseas is correct (thanks for this). The below help guide gives further instruction if you just ignore the SQL part.

http://www.seaward.co.uk/downloads/058___how_to_transfer_data_from_pg2_sql_to_pg3_v1.pdf