Data import and export

The term bulk operations is used to describe the process of importing and exporting data. Bulk operations are not part of typical end-user applications and must be executed by a user with DBA authority. Bulk operations may affect concurrency and transaction logs and should be performed when users are not connected to the database.

The following are typical situations in which data is imported or exported:

  • Importing an initial set of data into a new database

  • Building new copies of a database, perhaps with a modified structure

  • Exporting data from your database for use with other applications, such as spreadsheets

  • Creating extractions of a database for replication or synchronization

  • Repairing a corrupt database

  • Rebuilding a database to improve its performance

  • Obtaining a newer version of database software and completing software upgrades


Performance aspects of bulk operations
Data recovery issues for bulk operations
Data import
Data export
Access to data on client computers
Database rebuilds
Database extraction
Database migration to SQL Anywhere
SQL script files
Adaptive Server Enterprise compatibility