Combing Access DB into SQL

[qwertyas]

Hey guys is there a way I can combine my PT2 access DBs and convert them into SQL without using PT3

Thanks

[ptrack pat]

The only way to combine PT2 databases is to use the Utilities > Export Hand Histories To File option to export the hands in each database to text files which you would then use those files to import into the one PostgreSQL database.

[qwertyas]

Ok thanks for the help. How do I create an SQl db in PT2?

[ptrack pat]

Use the File > Maintain Database Names window to create a new, empty Access database.
Then you have to use the Utilities > Convert Database option to convert that new db to PostgreSQL.

[qwertyas]

When I try to convert my database it asks me to define my settings but I don't have anything in the ODBC drop down. What do I need to do? Do I need to install PostgreSQL manually from their website?

Thanks

[ptrack pat]

See this sticky post at the top of this forum...
viewtopic.php?f=29&t=5669

[qwertyas]

I installed an older version of SQL and managed to start importing hands from exported files but I can only import hands 10 thousand at a time. I have alot more hands is there a way to import more hands at once?

[ptrack pat]

Use the File > Auto-Import... > Generic Setup window - tell it what folder to look for the hand history files in.

[Nuck]

I am trying to convert access db to sql on pt2 and in the middle of conversion, a box pops up that says login-data source-PTRACKADDLHH-authorization-login name and password. Dont have a password.

[ptrack pat]

I am trying to convert access db to sql on pt2 and in the middle of conversion, a box pops up that says login-data source-PTRACKADDLHH-authorization-login name and password. Dont have a password.

It means one of the hand history database files that you have linked on the Utilities > Database Maintenance and Options window, Hand History DB's tab is corrupted. How many files are linked there? What are their file names?