Quote:
We are trying to migrate our database from pervasive 9.6.1 to SQL Server 2008.
I dont have any idea about pervasive.SQL.
|
Does your application support SQL Server? You can't just change the database underneath an application unless it supports the database.
Quote:
|
While I scan through the folder it had few folders, each having some .dat files and inside a subfolder called pvdata , few .mkd files and 1 .dct file.It does not contain any .ddf file
|
DDF files are used to describe the data files for access methods like ODBC, OLEDB, ADO.NET, PDAC, and ActiveX.
[/quote]We are tyring to create a tool which would dynamically read the .mkd files and put the data into sql server but how can I read the mkd files without .ddf files[/quote]
Only the Btrieve interface can read PSQL tables without the DDFs. You either need to get DDFs from the vendor of the application or create them your self.
Quote:
|
What does .dat and .dct file actually contain?
|
It depends. I've not heard of a .DCT file. .DAT files could be Btrieve files and they hold the actual data.