Quote:
|
Originally Posted by mirtheil
Short answer is to get DDFs (FILE.DDF, FIELD.DDF, and INDEX.DDF) that describe the field structure then use ODBC to export the data and then import the data to SQL Server.
You might look at the Pervasive Data Integrator product line. It's designed to move data from one source to a different destination.
You could also export the data to CSV and then use SQL Server to import it.
You will need a PSQL engine of at least the version the data files were created with. In your case, you'll need PSQL at least version 2000.
|
Thanks, Mirtheil. I have PSQL 10.10 trial version and Data Integrator 9 installed now. Since I don't have any DDF files yet but I do have all of the DAT files, how do I create a database and get the DDF files created? I'm struggling with understanding this. I thought I might just be able to attach to an existing database, but I'm not seeing that as an option.
Thanks,
Greg