Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
System table – sysobjects
Compatability view should be upgraded to catalog view.
Microsoft SQL Server 2000:
SELECT … FROM dbo.sysobjects
Microsoft SQL Server 2008:
SELECT … FROM sys.objects
Column conversion:
| Microsoft SQL Server 2000 (sysobjects) | Microsoft SQL Server 2008 (sys.objects) |
|---|---|
| id | object_id |
| xtype | type |
| uid | schema_id |
| name | name |