locked
Upgrade to sql server 2008 or 2012 ? RRS feed

  • Question

  • User-1057499591 posted

    Hello

    I need some advice.
    I started to work for a customer that today uses sql server 2000 and is going to upgrade sql server.

    The problem is the following:

    Customer is using Visual Studio 2008 to develop ASP applications and exe program.
    Customer still has one or two old Visual Basic 6 program running. (will start to convert to .Net..asap.
    Customer has crystal report in ASP application that is generated to PDF when geting reports.

    My questions are:

    Will the exe and asp programs work with sql server 2012 or do they need to convert to Visual Studio 2012 ?
    I guess the old Visual Basic programs will stop working ? (Connection to SQL server via ADO), they work today on Windows 7 64-bit.
    How till Crystal report work if upgrade all programs to Visual Studio 2012 do Crystal report support VS 2012 ?

    If problems with above they can upgrade to SQL Server 2008 but does that solve anything ?


    Thanks in advance for any advice
    //Micke

     

     


     


     

     

    Friday, May 24, 2013 7:37 AM

Answers

  • User281315223 posted

    According to this blog post, I don't believe that you can directly migrate from SQL Server 2000 to SQL Server 2012 (an intermediate step is required).

    If you are desiring to upgrade to SQL Server 2012 will you will basically need at least Visual Studio 2010 with Service Pack 1 (installation instructions here) to handle it, although ideally you should use Visual Studio 2012. (This is primarily if you want to use some of the database-related functionality within Visual Studio as the two technologies aren't exactly required for one another)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 24, 2013 7:50 AM

All replies

  • User281315223 posted

    According to this blog post, I don't believe that you can directly migrate from SQL Server 2000 to SQL Server 2012 (an intermediate step is required).

    If you are desiring to upgrade to SQL Server 2012 will you will basically need at least Visual Studio 2010 with Service Pack 1 (installation instructions here) to handle it, although ideally you should use Visual Studio 2012. (This is primarily if you want to use some of the database-related functionality within Visual Studio as the two technologies aren't exactly required for one another)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 24, 2013 7:50 AM
  • User364663285 posted

    You can ask them what the main reason is, that they want to upgrade the database. SS 2012 should be working fine for VS 2008.

    Monday, May 27, 2013 2:29 AM