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.

WebFOCUS |