Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

The requirement is to migrate some tables with data from a Oracle database server to Pervasive database's .DAT file. Then those .DAT files will be used by a Pervasive database server.

The restriction is that Oracle DB can not directly migrate to the Pervasive DB. It has to generate the .DAT files and then the new .DAT files will replace the old one for the Pervasive DB which will then use them for the new data.

I was trying this task with SSIS. Exporting the Oracle table to a delimited .txt file and then creating a .DAT file from that text file. I can export the data from Oracle to .txt but I am not finding any way to migrate .txt to Pervasive .DAT? Is this the right approach? If not then please help with my problem.

share|improve this question
    
I take it you are using Pervasive SQL, and not their Transactional ISAM database? –  Mark Henderson Jan 5 '10 at 2:02
add comment

1 Answer

If you are able to connect to the Pervasive database and execute SQL, you can use a tool like Oracle SQLDeveloper (http://www.oracle.com/technology/products/database/sql%5Fdeveloper/index.html) to export your data as SQL Inserts and then run those against your Pervasive database.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.