How to access .KDB database? [Archive]

DevilzOwn

03-06-07, 00:20

Hello guys,

Am new in here and also a noobie if you consider my database skills! I am decently acquainted with MySQL but absolutely ZILCH when it comes to any other database.

I have received a database application on a CD from a friend. The CD has a searchable database of companies in a particular state and my friend wants the data to be ported to his website.

I have searched through the directory structure of the CD and found a 126MB file with .kdb extension that I suspect holds all the data.

I need guidance on how to extract all the data and port it to mySQL.

Any help will be greatly appreciated.

Thanks a lot!

M Owen

03-09-07, 10:39

The .kdb file is a rdbms from KxSystems ... As for porting it, you might check their site www.kx.com for a driver to use for connecting to the database ... Say an ODBC driver ... Then you'll need to write the scripts in either mysql or some other dbms to extract and then write to yuor mysql db ...