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
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.