IBM DB2 to Snowflake Migration

SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from IBM DB2 to Snowflake.

Databases:

Migration Reference

Converting functions:

Converting CREATE SEQUENCE statements:

	DB2		Snowflake
1	CREATE [OR REPLACE] SEQUENCE seq_name		CREATE [OR REPLACE] SEQUENCE seq_name
2	INCREMENT BY num	Positive or negative increment, default is 1	INCREMENT BY num
3	START WITH num	Initial value	START WITH num
4	MAXVALUE num	Maximum value is num	Removed
4	NO MAXVALUE	System limit	Removed
5	MINVALUE num	Minimum value is num	Removed
5	NO MINVALUE	System limit	Removed
6	CYCLE	Reuse values after reaching the limit	Removed
6	NO CYCLE	No reuse, this is default	Removed
7	CACHE num	Cache num values	Removed
7	NO CACHE	Values are not preallocated	Removed
8	ORDER	Guarantee numbers in order of requests	ORDER
8	NO ORDER	No guarantee, this is default	NOORDER

Converting SQL statements: