I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardMS SQL Topic   Print This     

paradox 9 tables to mysql

paradox 9 tables to mysql in MS SQL topic (part of our DBA, Databases, & Data group).

Quick Search: paradox   paradox 9   paradox 9 tables  
Johnc
 (Inactive)
cheektowaga
Does anyone know how to convert paradox 9 tables into mysql? If so is the conversion simple and does paradox have a built in function or script that can be run to do this? Which tables are more stable for alot of users and records being accessed per day Paradox or SQL
Big Grin!
 Posted 20 years ago (Thread Starter)
Comment Quote
About Johnc -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2466, 3 replies
Thread Started 6/11/2001 10:16:00 AM
View Counter=5843
Last Reply Posted 9/30/2010 3:36:57 PM)
Location=cheektowaga  
Joined=20 years ago   MB Posts=25  
VBcrew
LA
I used to convert foxpro to mssql. So I assume Paradox to mssql is a same thing.

I will use ODBC and Visual Basic. I use VB as a front end and ODBC to retrieve data from paradox. And put those data into sql by using ODBC again.

VBcrew Big Grin!
 Posted 20 years ago
Comment Quote
About VBcrew -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2968 (Level 1.1)  Reply to 2466
Thread Started 7/12/2001 3:40:00 PM
View Counter=2
Location=LA  
Joined=20 years ago   MB Posts=6  
kwmillican
-- UNK

I created a Paradox 9 form for converting DB files to MySQL :-

http://www.millican.info/files/PDX9-ExportMySQL.zip

It's pretty basic but works with most of my files.

Copy the three tables and the form into your working directory and open the form. Click on the required table and press the export button. A folder called 'Export' will be created and MySQL import scripts created in there.

Only problem I've found with it is that my web host has a limit on a single import file size in PHPAdmin. Therefore I added an option to limit the number of records. Eg. if you had an 8100 record DB file and told the form to export 1000 records at a time, from a table called test.db, it will create nine files :-

test.sql
test(02).sql
test(03).sql
...
test(09).sql

The form uses three working tables :- MySQLexportFields.DB, MySQLexportFieldTmp.db, and MySQLexportTables.DB. Unlikely these will conflict with anyone's existing database.

(Just noticed the thread is ancient ! - ah well, maybe it's useful to someone else - lol)

 Posted 12 years ago
Comment Quote
About kwmillican -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13664 (Level 1.2)  Reply to 2466
Reply Posted 9/12/2009 3:37:38 PM
Location=-- UNK 
Joined=12 years ago   MB Posts=5   KB Comments=1  
Most Recent Post
eric_felleiter
-- USA

Thanks kwmillican I can use it.

 Posted 11 years ago
Comment Quote
About eric_felleiter -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14322 (Level 2.1)  Reply to 13664 and Parent is 2466
Thread Started 9/30/2010 3:36:57 PM
Location=-- USA 
Joined=13 years ago   MB Posts=1  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #2466 Counter
5843
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech