Data type conversions using schema migrations
SMT currently supports performing schema migrations for MySQL, PostgreSQL, SQLServer and Oracle. Certain features of relational databases, especially those that don’t map directly to Spanner features, are ignored, e.g. stored functions and procedures, and sequences. Types such as integers, floats, char/text, bools, timestamps, and (some) array types, map fairly directly to Spanner, but many other types do not and instead are mapped to Spanner’s STRING(MAX)
.
SMT supports converting to both GoogleSQL and PostgreSQL dialects of Spanner.