POC migrations for Oracle

Spanner migration tool can be run directly on a SQL Server database (via go’s database/sql package).

Following instructions assume you have setup SMT by following the instructions in the installation guide.

Table of contents
  1. Directly connecting to a SQL Server database

Directly connecting to a SQL Server database

In this case, Spanner migration tool connects directly to the SQL Server database to retrieve table schema and data. Set the -source=sqlserver and corresponding source profile connection parameters host, port, user, dbName and password.

For example, to perform schema conversion, run

spanner-migration-tool schema -source=sqlserver -source-profile="host=<>,port=<>,user=<>,dbName=<>"

Parameters port and password are optional. Port (port) defaults to 1433 for SQL Server source. Password can be provided at the password prompt.