Page 1 of 1

how to convert a PT2-Access-DB to PT3?

PostPosted: Fri Jan 30, 2009 10:43 am
by Olaf72
I really know nothing about Postgres and this seeems to be a Problem.
I was useing PT2 with an Access-DB and just installed PT3 with PostgreSQL without problems.
PT3 and PostgreSQL is working.
But i want to use my old Data (of course) and i'm completely stuck.

I went back to PT2 and selectet "Utilities->Convert Database..."
A dropdownlist has "convert to PostgreSQL" an there is a Button "Settings..."
In the Settings i have to enter a username this is "postgres" i guess,
then a password with i don't know and finally an "ODCB Entry to use" (no idea what this means)
the "ODCB Entry to use" is an empty dropdownlist with nothing to select.

the nearby Help-Link has nothing more to say and i don't know anything about postgreSQL.


[edit]
I'm runnig Windows XP

Re: how to convert a PT2-Access-DB to PT3?

PostPosted: Fri Jan 30, 2009 11:10 am
by kraada
It isn't necessarily necessary to convert the Access DB to PostgreSQL; the only reason you'd need to do that would be if you play tournaments, manually enter your results into PTv2 and want to convert that information over.

Otherwise, if you export your hands directly from the database in PTv2 by clicking Utilities --> Export Hand History to Disk ... and export all of the hands in your database to a new blank directory you can import them using the Manual Import tab of PT3 and all of your hands and information will be imported into PT3. (Manually entered tournament results don't transfer in that fashion, it's the only thing that doesn't.)

Re: how to convert a PT2-Access-DB to PT3?

PostPosted: Fri Jan 30, 2009 11:23 am
by Olaf72
hmmm... unfortunately my DB holds not a singel Ring-Game Hand but tournaments only :?

Re: how to convert a PT2-Access-DB to PT3?

PostPosted: Fri Jan 30, 2009 11:28 am
by kraada
Tournament hands will export, and imported summaries (if you got them from PokerStars) will export, it's only if you manually entered the results will they not export.

Re: how to convert a PT2-Access-DB to PT3?

PostPosted: Fri Jan 30, 2009 11:38 am
by Olaf72
There are manually entered results from Everst-poker.

I just installed a V8.2 of Postgres an now it seems PT2 can convert my Database....

... and it showed up in PT3 as well.

so i'm running postgresV8.2 with PT3 now :mrgreen:
try to get it to V8.3 now

thanks for the help

Re: how to convert a PT2-Access-DB to PT3?

PostPosted: Fri Jan 30, 2009 11:53 am
by kraada
Ah, ok :)

To convert from PostgreSQL 8.2 to 8.3, take a database backup as explained in the Database/Postgres FAQ, then uninstall 8.2, install 8.3 and restore from the backup and you should be all set.