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
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |