• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 894
  • Last Modified:

How to trans data from btrieve to Mysql?

I am writing a Visual Basic application. My boss went me trans data from a old btrieve database to a Mysql server. However, he doesn't want to use any third-party software and DSN. He just want me to use code to do that. How I can finish my job? Please help me.
0
peter_76
Asked:
peter_76
1 Solution
 
qatqatCommented:
If you export a normal ASCII file from your btrive DB then you can use the Mysqlimport utility to reimport it into MySQL
Move the ASCII file on the server
The syntax is (from command prompt):


mysqlimport -L --fields-enclosed-by= --fields-terminated-by= databasename text_file_path_and_name


Bye


Qatqat
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now