Sunday, September 2, 2012

How to migrate sybase to sql server?

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.              


  • Stored Procedures

  • Triggers
  • Tables
  • Views
  • Indexes
  • User Defined Data types
  • User Defined Defaults
  • Datums.
  • etc

  •                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
                         

    9 comments:

    1. Replies
      1. Except it's not about that. And is a shameless plug for your company.

        Delete
    2. SSMA do not transfer user types, when you know that this is much of the time a crucial part of the app framework, this make the tool very less interesting.

      ReplyDelete
    3. How do I know what Sybase drivers to install? and where do I get these?
      We are going from Sybase 15.0 on HP Unix to SQL Server 2014 on Windows 2012 R2.

      ReplyDelete
    4. Nice ,It is a relevant website for me and it made my day .Here , you can read the update about the Turkey visa cost. As per the requirement of time a little bit of change has been done in the Turkey visa cost. Many factors also directly affect the turkey visa cost like applicant country status and the type of visa you select etc.

      ReplyDelete