Sybase to MS SQL Server Migrarion:
Migration from Sybase to MS SQL Server is easiest way,when compare with creating/developing new architecture.It's highly Technical Migration not a functional Migration.Technical experts able to migrate easily.
There is lot of Tools available in the Market to reduce the human effort/time/cost .Some third party tools also available.I just provided some tools name here.
1.Sybase to SQL Server Migration Assistance(SSMA) a Microsoft Product.
2.SwisSQL a Third Party Product.
3.SQLWays a Third Party Product.
Microsoft only know very well about the Sybase and SQL Server Engines. And Microsoft recommending their native product SSMA.
The total Migration has two phases
1.Phase 1-Migration using tool
2.Phase 2-Manual conversion
First phase of project,creates the all object in the SQL Server Database from the Sybase source database. Sybase to SQL Server Migration Tool helps you migrate Sybase ASE (Adaptive Server Enterprise) T-SQL Procedures, inbuilt functions, triggers, tables, views, and other database objects to Microsoft SQL Server T-SQL.SSMA is a first of its kind product with a productive migration environment that offers .
Different type of Object can migrate using SSMA.Object types given below.
Configuring SSMA is the mandatory process.To configure and migrate the Sybase database using tool,please click the link shown below.
http://blogs.msdn.com/b/ssma/archive/2011/06/09/migrating-from-sybase-ase-to-sql-server-how-to-use-ssma-for-sybase.aspx
Download SSMA
Second phase is completely developers activity.Which deals about transact sql changes.Developers should handle the SSMA shown Errors,SSMA shown warnings.
Though the code has no errors/warnings explicitly ,developers should concentrate some specific
changes like cursor,null etc.If we miss the small changes,which leads to more time wastage in
later point of time.I am here to share my knowledge/experience about all errors/warnings
and required code changes i did in my last project.
You can find the detailed explanation of the errors/warnings and required changes from this blog.Please find the discussions in the further posts.
Please click here to know about sybase to sql server migration issues
