Btrieve Interview Question:

Tell me how to convert a bunch of .btr and .lck files to a readable SQL?

Submitted by: Administrator

-Every Btrieve file and DDf has a owner of their creation.

-Owner name can be used to read only access.

-SET OWNER = command is used before utilizing SELECT statement.

-.lck files are lock files and can not read them directly.

-.btr files are DDF files.

-The conversion can be made by using ODBC DSN that points to data and utilizes SSIS or DTS to export the data from.
Submitted by: Administrator