Importing data is an administrative task that involves reading data into your database as a bulk operation. Use SQL Anywhere to:
import entire tables or portions of tables from text files
import data from a variable
import several 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.
Performance tips for importing data
Import data with the Import Wizard (Interactive SQL)
Import data with the INPUT statement
Import data with the LOAD TABLE statement
Import data with the INSERT statement
Import data with the MERGE statement
Import data with proxy tables
Conversion errors during import
Importing tables
Table structures for import
Merge different table structures
Importing binary files
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |