Ispirer Website Ispirer Capabilities: Sybase IQ Migration Free Trial

Sybase IQ: Advanced Options

At the “Target Options” page of SQLWays Wizard you can see the button “Advanced”, which opens the window with additional options for target database:

Client-Side Character Set Conversion
This option specifies 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 to the ISQL and BCP utilities commands (Parameter -X). Possible values: “Yes”, “No”. Default value is “No”.

Batch Size
Specifies the number of rows per batch of data copied. By default, bcp copies n rows in one batch, where n is equal to the batch size. Batch size applies only when you are bulk copying in; it has no effect on bulk copying out. The smallest number bcp accepts for batchsize is 1. The largest number bcp accepts for batchsize is 2147483647L.

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