Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to migrate an old proprietary database (custom database based on a Btrieve engine) to a newer system . All I have to access this database is an ODBC driver that works pretty well. When I connect to the database, I only see views but still the database documentation provides the table names and I am able to access them even though the driver does not show them.

Unfortunately the database documentation is quite poor and does not allow me to generate the full schema. Some information like the column precision and scale is missing.

So is there a tool that would allow me to read the full database schema and dump it to a file ?

I really just need a description of the the tables like table name, column name, datatype, precision, scale and optionally comments. I don't even need relationship and keys. For the rest, I have enough skill to process those information and generate a script for my destination database.

Regards.

share|improve this question

1 Answer 1

Following on from chat in "The Heap"...

Visio can reverse engineer a database. However, I assume thus needs to read metadata or system tables to get everything (keys, DRI, datatypes the works).

This old MSDN article may help "Migrating Btrieve Applications to MS SQL Server 7.0" too

share|improve this answer
    
I forgot to mention that my goal is to simply make a 1 to 1 migration. Relations and keys are not needed. –  Ucodia Jun 13 '12 at 9:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.