Striim Migration Service for Google Cloud Documentation

Create the target tables

Before running the initial load application, you must create tables in the target that are compatible with those in the source. You may use any tool you wish.

If you choose to use SMSGC's schema conversion utility, the command is:

/opt/striim/bin/schemaConversionUtility.sh \
-s="oracle" \
-d="jdbc:oracle:thin:@//<IP address>:<port>/<SID or service name>" \
-u="<user name>" \
-p="<password>" \
-b="< database_name.% or a list of tables separated by semicolons>" \
-t="spanner"

For detailed instructions on using the schema conversion utility, see Create target tables using SMSGC's schema conversion utility.

To create the tables in Spanner, go to the instance details, select the target database, select Create Table, enable Edit as text, paste all the CREATE TABLE statements into DDL statements, and click Create.

SpannerCreateTables.png

To create the checkpoint table required for SMSGC to support recovery of the streaming integration application, paste the following into DDL statements and click Create:

CREATE TABLE CHKPOINT (
  ID STRING(MAX) NOT NULL,
  SOURCEPOSITION BYTES(MAX)
) PRIMARY KEY (ID);