开发者

How to convert a bunch of .btr and .lck files to a readable SQL?

开发者 https://www.devze.com 2023-02-14 13:31 出处:网络
I have a bunch of .btr and .lck files and I need to import those to a SQL Server Data Bas开发者_如何学JAVAe.

I have a bunch of .btr and .lck files and I need to import those to a SQL Server Data Bas开发者_如何学JAVAe.

How can I do that?


.LCK files are lock files. You can't (and don't need to) read those directly. The .BTR files are the data files. Do you have DDF files (FILE.DDF, FIELD.DDF, INDEX.DDF)? If so, you should be able to download a trial version of Pervasive PSQL v11 from www.pervasivedb.com. Once you've installed the trial version, you can create an ODBC DSN pointing to your data and then use SSIS or DTS or any number of programs to export the data from PSQL and import it to MS SQL.
If you don't have DDFs, you would need to either get them or create them. The DDFs describe record structure of each data file.

0

精彩评论

暂无评论...
验证码 换一张
取 消