SQL Server to Synapse Analytics

Code transformations

  • Incompatible options for SELECT statements are commented out. If all of the options are incompatible, the whole option clause is commented out.

  • Procedure parameters' default values are commented out, and a separate SET statement is inserted at the beginning of the body.

  • When last statement of a procedure body is RETURN with no expression returned, RETURN is commented out.

  • View attributes are commented out

  • User-defined type references are replaced with their base types

PreviousLimitationsNextOracle to PostgreSQL

Last updated