| layout | title | nav_order | has_children | permalink |
|---|---|---|---|---|
default |
Data Type Conversion |
8 |
true |
/data-types-conv |
{: .no_toc }
SMT currently supports performing schema migrations for MySQL, PostgreSQL, and Cassandra. For Cassandra, schema migrations are supported only to the GoogleSQL dialect. 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.