Page 1 of 1

Combing Access DB into SQL

PostPosted: Tue Jan 06, 2009 12:33 pm
by qwertyas
Hey guys is there a way I can combine my PT2 access DBs and convert them into SQL without using PT3

Thanks

Re: Combing Access DB into SQL

PostPosted: Tue Jan 06, 2009 4:54 pm
by 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.

Re: Combing Access DB into SQL

PostPosted: Sat Jan 10, 2009 3:10 pm
by qwertyas
Ok thanks for the help. How do I create an SQl db in PT2?

Re: Combing Access DB into SQL

PostPosted: Sat Jan 10, 2009 7:54 pm
by 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.

Re: Combing Access DB into SQL

PostPosted: Mon Jan 12, 2009 1:57 am
by 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

Re: Combing Access DB into SQL

PostPosted: Mon Jan 12, 2009 9:39 am
by ptrack pat
See this sticky post at the top of this forum...
viewtopic.php?f=29&t=5669

Re: Combing Access DB into SQL

PostPosted: Tue Jan 13, 2009 3:14 am
by 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?

Re: Combing Access DB into SQL

PostPosted: Tue Jan 13, 2009 9:27 am
by ptrack pat
Use the File > Auto-Import... > Generic Setup window - tell it what folder to look for the hand history files in.

Re: Combing Access DB into SQL

PostPosted: Fri Feb 20, 2009 1:48 pm
by 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.

Re: Combing Access DB into SQL

PostPosted: Fri Feb 20, 2009 5:54 pm
by ptrack pat
Nuck wrote: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?

highfalutin