Importing and exporting data

The term bulk operations is used to describe the process of importing and exporting data. Bulk operations must be executed by a user with DBA authority and are not part of typical end-user applications. 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
Importing data
Exporting data
Accessing data on client computers
Rebuilding databases
Extracting databases
Migrating databases to SQL Anywhere
Using SQL command files
Adaptive Server Enterprise compatibility