User Documentation
Ispirer Capabilities - Microsoft SQL Server Migration
Pricing
System table – systypes
Compatability view should be upgraded to catalog view.
Microsoft SQL Server 2000:
SELECT … FROM systypes
Microsoft SQL Server 2008:
SELECT … FROM sys.types
Column conversion:
| Microsoft SQL Server 2000 (systypes) | Microsoft SQL Server 2008 (sys.types) |
|---|---|
| xusertype | user_type_id |
| xtype | system_type_id |
| name | name |