Migration Checklist

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.
Convert ROLLBACK TRIGGER to savepoints.
Change Transaction Isolation Levels from Sybase numeric-level identifiers to Microsoft string-based identifiers.
User-supplied stored procedures must be moved from sybsystemprocs to master.
Change index and locking optimizer hints to Microsoft format.
Change permanent temporary tables to global tables.
Change range and add severity to user-defined messages.
Remove:
Arguments from PRINT statement
Sybase server roles
User-defined data cache references
Thresholds
Table partitioning
Make required syntax changes:
DUMP and LOAD statements
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
Message ranges change to >= 50000
Argument substitution such as C printf

Tuning options for read ahead.
Scrollable server cursors.
Encryption of stored procedures in syscomments.
Replace nested IF with CASE statement.
RPCs with results sets can be used in INSERTS.
Automatic scheduling of maintenance tasks, alerts, replication.
Extended stored procedures for mail notification, beep, scheduling.
Log user messages to Windows NT event log and/or SQL Server error log using xp_logevent.
Trusted connections and NT_username.
Auto-startup stored procedures.
EXECUTE strings.
SQL Web Page Wizard for HTML publication.
Database Maintenance Plan Wizard to set up administration.
SQL Trace to record filtered SQL activity.
SQL Executive auto-restart.
Change SELECT statement to use ANSI-style joins (INNER JOIN, CROSS JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN).