Data Load (SQL SVR, SYB ASE)

From RapidSQL
Jump to: navigation, search

Go Up to Data Load

DBArtisan offers a simple, six-step wizard that can load data via Microsoft SQL Server's BCP (bulk copy program) utility or via Sybase ASE's BCP (bulk copy program) utility. After defining the data import operation, you have the opportunity to save the job definition for future re-use.

Tip: For related information, see Data Unload (SQL SVR, SYB ASE).

To load table data

  1. Connect to the datasource where the data is to be loaded and ensure that it is the selected datasource. For details, see Connected/Selected Datasource options.
  2. Select Utilities > Data Load. The Data Load Wizard opens.
  3. The options and steps involved depend on the DBMS type and on the selections you make. Use the following table as a guide to providing details as you pass through the pages of the wizard.
Option Description

Do you wish to initiate a new data unload operation or ‘play back’ a previously saved operation?

New Data Unload Operation - Select to define a new data unload operation. ‘Playback’ Previous Data Unload Operation - Select to use a previously defined schema extraction operation. Then in the Data Unload Definition File Name box type the location and name of the job file or click the browse button.

Which database do you want to load the data into?

Lets you click the list, and then select the server. Then click the list and select the database.

Which table do you want to load the data into?

Lets you click the list, and then select the table.

Use BCP Utility

Select to use the BCP (bulk copy program) utility.

Which rows do you want to import?

All Rows Range - Lets you type the range in the First Row and Last Row boxes.

What restrictions do you want to place on the import?

Max Errors or Batch Size.

The following options are available against SQL Server datasources.

Data File

Lets you type the directory location of the data file or click the browse button to find the file.

Format

To use a format file, type the directory location of the format file or click the browse button to find the file.

Error File

To output errors to an error file, type the directory location of the format file or click the browse button to find the file.

What character delimited the columns in the datafile?

Lets you click the list, and then click the character.

Do you wish to re-use this data load operation?

To re-use the operation, type the location and name of the data load definition file or click the browse button to find the file. DBArtisan gives the operation a default extension of *.LOAD.

Do you wish to DROP the index(es) on the target table BEFORE copying data?

Drop Index(es) Before Loading of Data - Select to drop the indexes on the target table before copying data. Recreate Index(es) After Loading of Data - Select to recreate these indexes after the data loads.

The following options are available against Sybase ASE datasources.

Row Terminator

Lets you enter a value for this common BCP option.

Packet Size

Lets you enter a value for this common BCP option.

Text/Image Size

By default, Sybase ASE only copies the first 32K of data in a text or image field. To override default size, type a new size.

Client Char Set

Lets you enter a value for this common BCP option.

Max Connections

Lets you specify the maximum connection of connections in the connection pool.

Show-fi

Provides the option to add columns for each functional index.

Hide-vcc

Provides the option to hide virtual computed columns

4. Review the data unload operation description to verify its accuracy. If you need to make any changes, click Back to scroll back to the appropriate panels of the wizard to make your corrections. When ready, click Execute.