Migration Checklist

You must make the following changes to your Sybase database and applications before migrating to Microsoft SQL Server 7.0:

1. Change references to chained transaction mode to either unchained transactions or Microsoft implicit transactions. Change @@trainchain references to @@OPTIONS. Change @@transtate references to @@ERROR logic.
2. Convert ROLLBACK TRIGGER to savepoints.
3. Change transaction isolation levels from Sybase numeric-level identifiers to Microsoft string-based identifiers.
4. Move user-supplied stored procedures from sybsystemprocs to master.
5. Delete (preferably) or change index and locking optimizer hints to Microsoft format.
6. Change permanent temporary tables to global tables.
7. Change range and add severity to user-defined messages.
8. Remove:
   • Arguments from the PRINT statement.
   • Sybase server roles.
   • User-defined data cache references.
   • Thresholds.
   • Table partitioning.
9. Make required syntax changes:
   • Change DUMP and LOAD statements to BACKUP and RESTORE statements.
   • Change cursor processing (change @@sqlstatus to @@FETCH_STATUS).
   • Identity column default name changes to IDENTITYCOL.
   • SET TRANSACTION ISOLATION LEVEL.
   • SELECT statement optimizer hints.
   • sp_addmessage (message range and severity).
   • Reserved Microsoft keywords.
   • DBCC.
   • RAISERROR.
10. Change message ranges to >= 50,000.
11. Change argument substitution such as C printf.

Optionally, you can choose to make the following changes to your Sybase database and applications before migrating to Microsoft SQL Server 7.0:

• Change tuning options for read ahead.
• Change scrollable server cursors.
• Encrypt stored procedures in syscomments.
• Replace nested IF statements with the CASE statement.
• Use RPCs with result sets in INSERTS.
• Schedule automatic maintenance tasks, alerts, and replication.
• Use extended stored procedures for mail notification, paging, scheduling.
• Log user messages to the Windows NT application log and/or the SQL Server error log by using xp_logevent.
• Change trusted connections and NT_username.
• Start up stored procedures automatically.
• Change EXECUTE strings.
• Use the SQL Server Agent autostart functionality.
• Change the SELECT statement to use SQL-92–style joins (INNER JOIN, CROSS JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN).