Exporting data is an administrative task that involves writing data out of your database. Exporting data is a useful if you need to share large portions of your database, or extract portions of your database according to particular criteria. Use SQL Anywhere to:
export individual tables, query results, or table schema
create scripts that automate exporting so that you can export several tables consecutively
export to many different file formats
export data to a file on a client computer
export files between SQL Anywhere and Adaptive Server Enterprise using the BCP FORMAT clause
Before exporting data, determine what resources you have and the type of information you want to export from your database.
For performance reasons, to export an entire database, unload the database instead of exporting the data.
Exporting data with the Export Wizard
Tips on exporting data with the OUTPUT statement
Tips on exporting data with the UNLOAD TABLE statement
Tips on exporting data with the UNLOAD statement
Tips on exporting data with the Unload utility (dbunload)
Tips on exporting data with the Unload Database Wizard
Exporting data with the Unload Data window
Exporting query results using the OUTPUT statement
Exporting query results using the UNLOAD statement
Configure handling of NULL values in Interactive SQL
Exporting databases (Sybase Central)
Exporting databases (command line)
Exporting tables (SQL)
Exporting tables (command line)
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|