Post reply

upgrading sql 2000 to sql 2008 will make any problem to my database ?

  • October 15, 2012 at 5:28 am

    #268545

    hi,

    i am running sql 2000 now my company has decided to go for sql server 2008.

    i have many tables,indexes,functions,procedures in my database. if i upgrade it, will it make any problem to me ?

    Something like some function or procedure will not work properly in sql 2008 which is running ok in sql 2000.

  • October 15, 2012 at 6:48 am

    #1549107

    You can answer your questions by obtaining a copy of

    Microsoft SQL Server 2008 Upgrade Advisor

    http://www.microsoft.com/en-us/download/details.aspx?id=11455

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 16, 2012 at 7:03 am

    #1549529

    The answer is it depends. You need to have a test environment and test, test, test. If you don't have a test environment for the upgrade then you MUST get one. Look into and use the Upgrade advisor:

    http://www.microsoft.com/en-us/download/details.aspx?id=11455

Viewing 3 posts - 1 through 2 (of 2 total)

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