I want to export data dynamically out of an existing commercial application that uses btrieve version 6.15. In other words, while the commercial application is using these files, I want to write changes to the data to an external sql database.
I plan to use BTSearch32, a utility, to construct the DDF files.
My next step will be to write a java program that will read the btrieve files from the application using the 6.15 version and write this data to a SQL database.
My question is: What pervasive product should I use to do this? I'd like to use JDBC in Java if possible. If I use pervasive.sql v8, will v8 be able to share the data files with the commercial application? Is pervasive.sql 2000 a viable alternative?
What is the best way product for my need and will it support my plans?
Thanks.
I plan to use BTSearch32, a utility, to construct the DDF files.
My next step will be to write a java program that will read the btrieve files from the application using the 6.15 version and write this data to a SQL database.
My question is: What pervasive product should I use to do this? I'd like to use JDBC in Java if possible. If I use pervasive.sql v8, will v8 be able to share the data files with the commercial application? Is pervasive.sql 2000 a viable alternative?
What is the best way product for my need and will it support my plans?
Thanks.