Post reply

upgrade from 2000 to 2005

  • November 22, 2005 at 8:00 am

    #169793

    Hi,

    Just a simple question, we currently use sql server 2000 enterpise in the office to develop and test client applications.

    We are thinking about upgrading to sql server 2005 enterprise in the office:-

    a) would we still be able to use the databases developed in 2000 as is without any changes.

    b) if we implemented new/updated applications in sql 2005 and customers still had sql 2000 would they still function without getting the customer to upgrade as well.

     

    Thanks in advance

     

     

  • November 22, 2005 at 9:29 am

    #605271

    As long as you only use SQL 2000 functionality on the SQL 2005 server it will work for all your customers you can set the compatability level to SQL 2000 so that it should only work with SQL 200o features, but I would always check by doing a test run on a SQL 2000 before sending out to clients.

    Kindest Regards,

    bryan.oliver@quest.com

    quest.com

  • November 22, 2005 at 12:11 pm

    #605303

    Hi Bryan,

    Thanks for your comment, I will bear this in mind once I upgrade to sql 2005.

    Incidentally, can sql 2000 and sql 2005 coexist on the same server.

     

  • November 22, 2005 at 1:28 pm

    #605320

    It is my understanding that DTS packages from 2000 will not run on 2005. Is this correct?

    What else does not run?

  • November 23, 2005 at 2:37 am

    #605407

    DTS packages can also be run under a kind of 2000 emulation, 2005 puts a wrapper around them.

    There are lots of little changes here and there across the board from the database engine through integration services.

    If you are deploying SQL with your application to your customers, my advice would be to move to 2005 in the next release rather than try to support multiple versions on corporate and client locations.

  • November 23, 2005 at 9:07 am

    #605482

    SQL Server 2000 and SQL Server2005 can co-exist on the same server. However, be sure to install SQL Server 2000 first and then SQL Server 2005.

  • November 23, 2005 at 11:30 am

    #605512

    You should download the Microsoft SQL Server 2005 Upgrade Advisor.  This will help you find upgrade problems before you actually upgrade.  You can also run a Profiler trace on your current system and run it through the Upgrade Advisor to help find problems with your code.  It looks pretty cool.  http://www.microsoft.com/downloads/details.aspx?FamilyID=6107c27a-662c-4319-afe7-b52d1568c30a&displaylang=en

    Linda

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply