locked
sql server Migration from sql server 2008R2 to SQL SERVER 2012 RRS feed

  • Question

  • Hi All,

    We are planning SQL Server Migration from 2008 To 2012, Request to you please suggest what are pre-post actions I have to follow only databases No more other services

    Regards


    subu

    Tuesday, July 22, 2014 3:06 PM

Answers

  • Hi All,

    We are planning SQL Server Migration from 2008 To 2012, Request to you please suggest what are pre-post actions I have to follow only databases No more other services

    Regards


    subu

    My first question would be did you tested you application functionality with SQL Server 2012. If not please do it and unless you are sure it is working as it was with SQL Server 2008 until then do not give a sign off.

    Pre:

    How are you planning to migrate In place upgrade or side by side if you just use DB engine services you can go for In place upgrade if you have complex environment you should go for side by side migration which would involve installing SS2012 and then moving database using backup restore and then moving login,jobs, packages and other SQL Server related stuffs

    First please run upgrade advisor if it points out issues please remove it then only proceed with in place upgrade

    If You are going for side by side approach

    Migrate database using backup restore

    Migrate logins, refer to this Link

    Migrate using Script out method or you can use SSIS to migrate jobs

    Migrate/Upgrade SSIS packages

    Post

    I am sure you would see some slowness.

    Post steps would be

    1. Rebuild indexes for all tables

    2 Update statistics

    3. Run DBCC CHECKDB for all databases

    4 Set optimum value for max server memory

    4. Monitor SQL Server behavior closely how it is performing.

    Complete reference link

    http://msdn.microsoft.com/en-gb/library/bb677622%28v=sql.110%29.aspx


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Tuesday, July 22, 2014 6:34 PM
  • For SQL 2000 you need to first migrate to 2005 or 2008 before you can migrate to 2012.

    For SQL 2005 you can directly migrate if it is in SP4.

    Check this

    http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by Elvis Long Tuesday, July 29, 2014 8:39 AM
    Thursday, July 24, 2014 10:51 AM

All replies

  • Hi All,

    We are planning SQL Server Migration from 2008 To 2012, Request to you please suggest what are pre-post actions I have to follow only databases No more other services

    Regards


    subu

    My first question would be did you tested you application functionality with SQL Server 2012. If not please do it and unless you are sure it is working as it was with SQL Server 2008 until then do not give a sign off.

    Pre:

    How are you planning to migrate In place upgrade or side by side if you just use DB engine services you can go for In place upgrade if you have complex environment you should go for side by side migration which would involve installing SS2012 and then moving database using backup restore and then moving login,jobs, packages and other SQL Server related stuffs

    First please run upgrade advisor if it points out issues please remove it then only proceed with in place upgrade

    If You are going for side by side approach

    Migrate database using backup restore

    Migrate logins, refer to this Link

    Migrate using Script out method or you can use SSIS to migrate jobs

    Migrate/Upgrade SSIS packages

    Post

    I am sure you would see some slowness.

    Post steps would be

    1. Rebuild indexes for all tables

    2 Update statistics

    3. Run DBCC CHECKDB for all databases

    4 Set optimum value for max server memory

    4. Monitor SQL Server behavior closely how it is performing.

    Complete reference link

    http://msdn.microsoft.com/en-gb/library/bb677622%28v=sql.110%29.aspx


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Tuesday, July 22, 2014 6:34 PM
  • Hi Sanky,

    Please see the below steps

    I m planning this plan any thing wrongs please correct me

    Note:Rebuild  index and update stastics not required

    Because we are configuring new Maintaince plan for all jobs. If any thing wrong please correct me.

    Thanks in advance for your support.

    Take Full database backup of all user databases
    Copy those database backups from 2008  to 2012 server
    Restore all user databases New Sql server 2012
    Change the compatability level all the databases 
    Take logins and users scripts from 2008 Server
    Execute all login and users in sql server 2012 box
    Take all sql server jobs scripts from sql server 2008
    Execute all jobs scripts in sql server 2012 box
    Create database Maintains plan jobs for Database bacups Re-build the indexs and update stastics 
    Need configure the High availablity of all user databases 


    subu

    Wednesday, July 23, 2014 7:47 AM
  • Hi Seems fine just below

    EDIT:Please run update stats and rebuild index before proceeding and also run checkdb


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles


    Wednesday, July 23, 2014 11:11 AM
  • Apart from these few other things that you might want to check are

    Linked Servers - If at all you have any configured

    Sp_configure - Confirm all the settings which might effect this database are setup correctly in the new server

    Also in the new server, along with Upgrade Advisor, I would also run SQL 2012 BPA to make sure that everything looks good.

    http://www.mssqltips.com/sqlservertip/2712/using-the-microsoft-sql-server-2012-best-practice-analyzer/


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Wednesday, July 23, 2014 11:46 AM
  • Hi Team,

    We have few servers in SQL SERVER 2000 and SQL SERVER 2005 is it possible to migrate to SQL SERVER 2012?


    subu

    Thursday, July 24, 2014 9:52 AM
  • For SQL 2000 you need to first migrate to 2005 or 2008 before you can migrate to 2012.

    For SQL 2005 you can directly migrate if it is in SP4.

    Check this

    http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by Elvis Long Tuesday, July 29, 2014 8:39 AM
    Thursday, July 24, 2014 10:51 AM
  • For SQL 2000 you need to first migrate to 2005 or 2008 before you can migrate to 2012.

    You dont need to completely migrate it to 2005/2008/r2 first,restriction lies with backup restore. It is just that you need to restore SQL server 2000 backup on 2005/2008/r2 you can take out jobs and login script and can run in 2012 to create it

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Thursday, July 24, 2014 3:35 PM
  • Thanks for making it clear Shanky.. I can see that my statement was not clear enough !!

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Thursday, July 24, 2014 3:44 PM
  • Hi,

     Also check if any Linked server connection exists. Script out that and migrate .

    Check sp_configure settings on existing server.


    Please Mark As Answer if it is helpful. \\Aim To Inspire Rather to Teach A.Shah

    • Proposed as answer by -kit Thursday, July 24, 2014 5:16 PM
    Thursday, July 24, 2014 5:16 PM
  • Logicinside

    And what is need to propose you own answer please let others do it.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Thursday, July 24, 2014 6:56 PM
  • Thanks for making it clear Shanky.. I can see that my statement was not clear enough !!

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    You are welcome Ashwin :)

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Thursday, July 24, 2014 6:58 PM