Automated Bulk ImportAutomated bulk import allows you to load the SonicBase database from another JDBC compliant database. Before initiating the bulk import you must create all the tables and indices in your SonicBase database. The SonicBase schema must match the schema in your source database or be a subset of that schema. You can quickly load the database in a single command.
Bulk Import CommandIn the admin client type the following command:
start bulk import from <tableName>,<tableName>(<datbase driver>, <jdbc url>, <user>, <password>) where <expression>
start bulk import from persons(com.mysql.jdbc.Driver, jdbc:mysql://localhost/test)
You may specify all the the tables you want to import in a single command. However, if you have a where clause you can only specify one table. The where clause can be used to limit what records are imported. The where clause is optional. User and password are optional. "database driver" is the database driver class of your source database. "jdbc url" is the connect url for your source database. The comma and following space in the command is required for proper parsing of the command.
Importing a table with no primary key will be slower than a table that has a primary key.