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
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |