Slashdot Mirror

← Back to Stories (view on slashdot.org)

Manual migration from MS SQL Server to MySQL

Posted by timothy on from the minimizing-handwork dept.

Mark Brunelli, News Editor writes "It's no small feat to manually migrate an enterprise from Microsoft SQL Server to MySQL, but it can be done. Here, Mike Sheffey, CEO of Versora, gives step-by-step instructions for two manual tasks: moving the data structure and the data itself."

3 of 44 comments (clear)

  1. Similar migrations by MobyDisk · · Score: 5, Funny

    This is the kind of news that PHBs need to hear. These types of migrations are possible! I plan to write some similar articles on migrating some other proprietary produces to F/OSS software, including:

    Microsoft Office --> VI
    ASP.NET --> sh scripts
    Peachtree Accounting --> GnuCash
    PeopleSoft --> awk
    Rational Rose --> GIMP

    1. Re:Similar migrations by bluGill · · Score: 1, Funny

      As one who sides with the "should have done PostgreSQL instead" crowd:

      Microsoft Office --> TeX
      ASP.NET --> python and php.
      Rational Rose --> Umbrello

      I'm not sure what PeopleSoft does, but I suspect there are better alternatives. I've been told there is a nice web based tool for accounting that works well, but I forget what it is. Though the double entry bookkeeping of GnuCash is a good choice, better than MySql as a replacement for MSSQL.

      Not that my first two choices are better. (TeX once you learn it does much better layout, and python is a nice scripting language overall)

  2. Great Revenue source for MS by Lord+Kano · · Score: 2, Funny

    If they released a product to automate the migration from their SQL server to MySQL or PostgreSQL.

    Seriously, they could squeeze a few more bucks out of the people who are no longer going to be using one of their products.

    LK

    --
    "Hi. This is my friend, Jack Shit, and you don't know him." - Lord Kano