Understanding the Migration Process
Three areas must be considered during a migration from Sybase Adaptive Server Enterprise to Microsoft SQL Server: data and object definitions, Transact-SQL and system stored procedure language changes, and administrative changes.
The steps of the migration process are:
- Review the architectural differences between Microsoft SQL Server and Sybase SQL Server that require changes to administrative procedures.
- Migrate data and objects using Microsoft SQL Server Data Transformation Services (DTS).
- Review Sybase stored procedures, triggers, SQL scripts, and applications for necessary language changes.
- Make the necessary changes to client code. Sybase SQL statements issued by applications must reflect changes to object names forced by keyword conflicts. The Sybase application SQL must reflect any changes required to comply with Microsoft Transact-SQL syntax.
- Test the client code.
- Make required changes to the customer’s administrative procedures.
- Review the new features available in Microsoft SQL Server and make changes to take advantage of these features.