GoogleCloudPlatform/spanner-migration-tool

Session file from UI not directly usable

bharadwaj-aditya opened this issue · 0 comments

Expected Behavior

Session file downloaded from UI should be usable automatically.

Actual Behavior

Fails with error
FATAL error: running data migration for Spanner dialect: spanner, whereas schema mapping was done for dialect:

Steps to Reproduce the Problem

  1. Import sample singers database on UI
  2. Download session file from UI
  3. Use HarbourBridge data command to migrate
    Command run
    /harbourbridge data -session="session.json" -source="mysql" -source-profile="host=localhost,user=abc,db_name=singers" -target-profile="instance=sample,dialect=spanner"

Manual Fix:
To manually add spanner in the TargetDb section of the session.json