locked
Difference between RRS feed

  • Question

  • Hi Team,

     

    What is difference between Migration and Upgradation... please guide me.

     

    Tx

    subu


    subu
    Saturday, June 11, 2011 10:15 AM

Answers

  • Hello,

    When you are upgrading a SQL Server instance, you are installing a new SQL Server version/release over an earlier version of SQL Server, where the databases are migrated to new version during the upgrade process or after.

    When you are performing a migration you have two SQL Server instances side-by-side, different versions/releases, and you are migrating databases/jobs/alerts/packages/etc. from the older version to the newer version of SQL Server.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    • Proposed as answer by Mr. Wharty Monday, June 13, 2011 5:37 AM
    • Marked as answer by WeiLin Qiao Tuesday, June 14, 2011 9:40 AM
    Saturday, June 11, 2011 1:30 PM
  • Hi Subu,

    Upgrade can be done from previous version of SQL Server to current version.

    Migration can be done from Heterogeneous database environment to SQL Server. Ex. Oracle, MySQL, Sybase or Access to SQL Server

    Microsoft provides the following Migration Assistants for free

    Microsoft SQL Server Migration Assistant for Access 5.0 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4b37df74-7522-41cf-9c1a-01b6415d9608 (REad this article for step by step instructions http://sqlxpertise.com/2011/04/27/migrating-access-databases-to-sql-azure/)

    Microsoft SQL Server Migration Assistant for MySQL v 5.0 - http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ac017a90-3b53-49b6-92a7-0f91623ef530

    Microsoft SQL Server Migration Assistant for Oracle v5.0 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5f63cd80-b928-4384-94ba-f1ba6eaf098f

    Microsoft SQL Server Migration Assistant for Sybase v5.0 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e741f2c5-f383-43e3-9a20-987e7984c8d4

    FYI, You can use this tools to migrate to SQL Azure as well.
    For Migrating SQL Server database to SQL Azure, you can use the following tools
    SQL Azure Migration Wizard - http://sqlazuremw.codeplex.com/
    DACImportExportCLI - https://www.sqlazurelabs.com/ImportExport.aspx - Read this article for detailed instructions on how to use that http://sqlxpertise.com/2011/05/11/dacimportexportcli-import-export-data-from-sql-azure-to-sql-server-vice-versa/
    If you have any specific questions regarding Upgrade or Migration, Please post your questions.


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, let us know by clicking "Vote as Helpful" and Propose as Answer
    • Proposed as answer by Mr. Wharty Monday, June 13, 2011 5:37 AM
    • Marked as answer by WeiLin Qiao Tuesday, June 14, 2011 9:40 AM
    Sunday, June 12, 2011 11:32 AM

All replies

  • Hello,

    When you are upgrading a SQL Server instance, you are installing a new SQL Server version/release over an earlier version of SQL Server, where the databases are migrated to new version during the upgrade process or after.

    When you are performing a migration you have two SQL Server instances side-by-side, different versions/releases, and you are migrating databases/jobs/alerts/packages/etc. from the older version to the newer version of SQL Server.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    • Proposed as answer by Mr. Wharty Monday, June 13, 2011 5:37 AM
    • Marked as answer by WeiLin Qiao Tuesday, June 14, 2011 9:40 AM
    Saturday, June 11, 2011 1:30 PM
  • Hi Alberto,

     

     Thank you very much for your reply...

     

    Tx

     


    subu
    Sunday, June 12, 2011 3:35 AM
  • Hi Subu,

    Upgrade can be done from previous version of SQL Server to current version.

    Migration can be done from Heterogeneous database environment to SQL Server. Ex. Oracle, MySQL, Sybase or Access to SQL Server

    Microsoft provides the following Migration Assistants for free

    Microsoft SQL Server Migration Assistant for Access 5.0 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4b37df74-7522-41cf-9c1a-01b6415d9608 (REad this article for step by step instructions http://sqlxpertise.com/2011/04/27/migrating-access-databases-to-sql-azure/)

    Microsoft SQL Server Migration Assistant for MySQL v 5.0 - http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ac017a90-3b53-49b6-92a7-0f91623ef530

    Microsoft SQL Server Migration Assistant for Oracle v5.0 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5f63cd80-b928-4384-94ba-f1ba6eaf098f

    Microsoft SQL Server Migration Assistant for Sybase v5.0 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e741f2c5-f383-43e3-9a20-987e7984c8d4

    FYI, You can use this tools to migrate to SQL Azure as well.
    For Migrating SQL Server database to SQL Azure, you can use the following tools
    SQL Azure Migration Wizard - http://sqlazuremw.codeplex.com/
    DACImportExportCLI - https://www.sqlazurelabs.com/ImportExport.aspx - Read this article for detailed instructions on how to use that http://sqlxpertise.com/2011/05/11/dacimportexportcli-import-export-data-from-sql-azure-to-sql-server-vice-versa/
    If you have any specific questions regarding Upgrade or Migration, Please post your questions.


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, let us know by clicking "Vote as Helpful" and Propose as Answer
    • Proposed as answer by Mr. Wharty Monday, June 13, 2011 5:37 AM
    • Marked as answer by WeiLin Qiao Tuesday, June 14, 2011 9:40 AM
    Sunday, June 12, 2011 11:32 AM
  • Hi Arun,

     

    Thank you..i got good information..

     

    Tx

     


    subu
    Monday, June 13, 2011 5:35 AM
  • Hi Subu,

    If you found this post useful, Please Mark as Answer or Vote as Helpful.

    Thanks,


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, let us know by clicking "Vote as Helpful" and Propose as Answer
    Tuesday, June 14, 2011 12:30 AM