Converting SQL Server to WebFOCUS 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.