|Summary:||How to improve performance by using the BulkInsert setting for replications to SAP Sybase ASE|
If replicating in Refresh mode to SAP Sybase ASE, DBMoto supports use of the Bulk Insert feature to increase performance with version 16.0 and above of Sybase ASE and .NET provider Sybase.AdoNet4.AseClient.dll. To use the Bulk Insert feature:
- Enable the Bulk Insert feature on the Sybase ASE database.
- Set the charset on the Sybase ASE database as follows: "Charset=iso_1;"
- In DBMoto, add the following token to the connection string: "EnableBulkLoad=2;"
- After creating the connections and setting up the replication in DBMoto, edit the Replication Properties to set the Refresh Options BulkInsert and Block Size.