Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Importing and exporting data


Importing data

Importing data is an administrative task that involves reading data into your database as a bulk operation. SQL Anywhere lets you:

  • import entire tables or portions of tables from text files
  • import data from a variable
  • import a number of tables consecutively by automating the import procedure with a script
  • insert or add data into tables
  • replace data in tables
  • create a table before the import or during the import
  • load data from a file on a client computer
  • transfer files between SQL Anywhere and Adaptive Server Enterprise using the BCP format clause

If you are trying to create an entirely new database, consider loading the data using LOAD TABLE for the best performance.

For more information about unloading and reloading complete databases, see Rebuilding databases.

See also

Import considerations
Performance tips for importing data
Import tools
Handling conversion errors during import
Importing tables