Analytica Business Systems: Pervasive.SQL and Btrieve Specialists

Pervasive.SQL, Btrieve and More KnowledgeBase | Article #50 | How to Do Bulk Imports in Pervasive.SQL
View an Article   Back
Title: How to Do Bulk Imports in Pervasive.SQL 
Category: Pervasive.SQL PSQL General 
Keywords: bulk imports, pervasive, btrieve 
Description: Question:
How do you do bulk imports to a Pervasive.SQL or Btrieve database?

Answer:
1. Create the new file, using either BUTIL -CLONE or the CREATE function from the Btrieve API.
2. The fastest method of loading the file is with an application running on the server using the Btrieve API.
3. The fastest program technique for loading the file is to create the file (remember the CREATE API function?) using no keys and once the file is loaded, close the file and create all the keys using the CREATE INDEX API function. 
Approved

If you like our free Pervasive Knowledge Base Service, please consider purchasing your next Pervasive Software Product from our online store or call or email us!

In the meantime, to help us keep this service free, would you mind clicking on one of the ads at the left? Thanks for visiting!