Sybase Adaptive Server Enterprise (ASE): Advanced Options

At the “Target Options” page of SQLWays Wizard you can set up some additional options for configuring the target database. If you press on button “Advanced” at “Target Options” page the corresponding window will open.

Client-Side Character Set Conversion
You could use this option for specification of client-side character set conversion for the BCP utility (Parameter -Y). Possible values: “Yes”, “No”. Default value is “No”.

Client-Side Password Encryption
Specifies the client-side password encryption (parameter -X) to the ISQL and BCP utilities commands. It could takes following values: “Yes”, “No”. By default takes value “No”.

Batch Size
By default, bcp copies n rows in one batch, where n is equal to the batch size. You can specify the number of rows per batch of data copied by using this option. Batch size applies only when you are bulk copying in; it has no effect on bulk copying out. The minimum value bcp accepts for batchsize is 1. The maximum values bcp accepts for batchsize is 2147483647L.

If you have any other questions, please feel free to contact our support technical team: support@ispirer.com