Converting SQL Server to Hyperstage
If you have an existing SQL Server schema definition,
you should perform the following steps to make it work on Hyperstage:
- Convert MEDIUMTEXT
to VARCHAR (N), where N is
only as large as necessary.
- Convert LONGTEXT
to VARCHAR (N), where N is
only as large as necessary.
- Convert DOUBLE(A,B)
to DECIMAL(A,B).
- Convert MONEY to
DECIMAL(18,4).
- Convert SMALLMONEY
to DECIMAL(6,4).
- INTEGER types may
be converted to BIGINT.
- NCHAR/NVARCHAR should
be converted to CHAR/VARCHAR.
- Convert NUMBER to
INTEGER.
- Convert NUMBER(A,B)
to DECIMAL(A,B).
Note: These steps are for converting DDL manually without
having to use WebFOCUS Quickcopy or iWay software to migrate data.