Post reply

Upgrading a sql script targetted for SQL 2000 database to target for SQL 2005 database.

  • October 9, 2009 at 3:15 am

    #385542

    Hi All,

    I have a script written for SQL 2000 database which gets the information about objects like, tables, stored procedures, user defined data types etc. I am looking to use the same script for SQL 2005 database. Please guide me on the possible modifications that I may need to make to use the same script on any SQL 2005 database.

    Thanks.:w00t:

  • October 9, 2009 at 4:12 am

    #1063960

    Sachin Vaidya (10/9/2009)

    Hi All,

    I have a script written for SQL 2000 database which gets the information about objects like, tables, stored procedures, user defined data types etc. I am looking to use the same script for SQL 2005 database. Please guide me on the possible modifications that I may need to make to use the same script on any SQL 2005 database.

    Thanks.:w00t:

    Best way (and easiest I guess) could be to just run it on test/dev and see what errors you get!

    This is a better document for you to start with. (comprehensive one!)

    http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

    ---------------------------------------------------------------------------------

  • October 9, 2009 at 11:02 am

    #1064251

    you could run it through the upgrade advisor, but without seeing the script, there's no way we can guess as to what might be broken.

    lots of stuff works, but if you've coded against system objects, I'd check the 2005 BOL entries for those pages to see if they're deprecated.

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

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