locked
Migration from SQL Server 7 to SQL Server 2012 RRS feed

  • Question

  • Hi Everyone,

    I've a database, which is made in SQL Server 7 (Schema + Database). I want to migrate all the database + schema to SQL Server 2012 without affecting the application.

    What could be the best and easiest approach to solve this issue. Please suggest something. I'll be very thankful to you.

    Thanks in advance.


    Janshair Khan

    • Moved by Olaf HelperMVP Thursday, May 7, 2015 6:28 AM Moved from "Database Engine" to a more specific forum
    Thursday, May 7, 2015 6:04 AM

Answers

  • Thanks for the support.

    What do I've to change in the application code? Do I've to change the data access code in the application or something else. Please kindly name them and tell me the possible and cheap way of migration. Thank You


    Janshair Khan


    Well i cannot tell you from here I have no idea about your code you would have to do it by yourself or take help of specialist who can have physical access to your SQl Server 7. Plus direct migration is not possible you have to migrate it to SQL Server 2005/2008/2008 r2 and then to SQL Server 2012.

    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 Article

    MVP

    • Marked as answer by Janshair Khan Thursday, May 7, 2015 9:05 AM
    Thursday, May 7, 2015 9:02 AM

All replies

  • Hi Everyone,

    I've a database, which is made in SQL Server 7 (Schema + Database). I want to migrate all the database + schema to SQL Server 2012 without affecting the application.

    What could be the best and easiest approach to solve this issue. Please suggest something. I'll be very thankful to you.

    Thanks in advance.


    Janshair Khan


    If your current application is compatible with SQL Server 7 and you are migrating to SQL Server 2012 the application will be affected in terms that log of features in SQL server 7 are now no where in SQL Server 2012 so you have to make changes to application code. Dont be in idea that application would function seamlessly

    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 Article

    MVP

    Thursday, May 7, 2015 6:09 AM
  • Thanks for the support.

    What do I've to change in the application code? Do I've to change the data access code in the application or something else. Please kindly name them and tell me the possible and cheap way of migration. Thank You


    Janshair Khan


    Thursday, May 7, 2015 6:38 AM
  • Thanks for the support.

    What do I've to change in the application code? Do I've to change the data access code in the application or something else. Please kindly name them and tell me the possible and cheap way of migration. Thank You


    Janshair Khan


    Well i cannot tell you from here I have no idea about your code you would have to do it by yourself or take help of specialist who can have physical access to your SQl Server 7. Plus direct migration is not possible you have to migrate it to SQL Server 2005/2008/2008 r2 and then to SQL Server 2012.

    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 Article

    MVP

    • Marked as answer by Janshair Khan Thursday, May 7, 2015 9:05 AM
    Thursday, May 7, 2015 9:02 AM
  • From a database perspective: -

    The first thing to be aware of is that you need to migrate from SQL Server 7 to 2005 (upgrade the database to 2005), and then to 2012  (upgrade the database to 2012).

    There is a very real possibility that your stored procedures, functions and Views may be attempting to run code that is no longer compatible, e.g. you may be using master.dbo.xp_sendmail instead of msdb.dbo.sp_send_dbmail or you could be calling master.dbo objects which have since moved to master.sys; so you need to go through your stored procedures.

    From an Application perspective, e.g. for your connections, is the Application AD aware? If not then Windows Authentication could be an issue.


    Please click "Mark As Answer" if my post helped. Tony C.

    Thursday, May 7, 2015 9:10 AM