many databases. merge a possibility ?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

many databases. merge a possibility ?

Postby celtic123200 » Tue Aug 23, 2011 6:51 am

I have created a few databases over the last 2 years with PT3. It seemed a good Idea at the time. some are backups, some are experiments on new strategies.
Is there anyway easy way to merge these into one master DB and delete duplicates? I also want to link up my different aliases on different networks.

Thanks Celtic
celtic123200
 
Posts: 102
Joined: Thu Dec 17, 2009 2:38 pm

Re: many databases. merge a possibility ?

Postby kraada » Tue Aug 23, 2011 8:29 am

There is unfortunately no easy way to do this. The best way is going to be exporting the hands from each database (though obviously you can except one) and reimporting everything into one database. So if you make your current largest database the "master" you'll save some time instead of starting completely from scratch.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 21 guests

cron