Emulation scenarios

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
Next
Oracle to PostgreSQL