Migration to SQL Server

  • Admingod


    Points: 5693

    I am working on migration project and doing the conversion using SSMA. Checking to see if anyone has done the migration from Sybase to SQL Server. If yes, can you list some of the issues identified. I have identified some of the issues and happy to share but just wanted to check with anyone here that has really worked on it and has any inputs or advise that the migration can be done in a better way? Thanks in advance!

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Sue_H

    SSC Guru

    Points: 90378

    I never kept a list of everything but the migration assistant will pick up most things and provide workarounds and additional information for the ones the assistant didn't convert. And then you test and test and test...just like any other migration. There used to be more documentation on going Sybase to SQL Server but I don't see very much recently published. It's likely difficult to keep up with all the changes with each platform.  Some of the older docs would still be a good reference. Refer to this article and then the link at the very bottom of the article for the pdf  "Guide to Migrating from Sybase ASA to SQL Server 2008"

    Migrating Sybase ASE to SQL Server: Similarities and Differences to Help in Planning a Migration Project


  • Jeff Moden

    SSC Guru

    Points: 995467

    Lately, the migration assistant also transmits a shedload of information about the servers involved to Microsoft, which I don't believe I want them to have no matter how benign they claim it might be.  For that reason, I don't use the migration assistant anymore.  Your thoughts on the subject may differ from mine but at least you know now.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply