Post reply

Migrate Sql server 2000 database to Sql server 2005

  • May 15, 2008 at 8:29 am

    #121646

    Hi,

    I want to migrate Sql server 2000 to sql server2005.

    I followed the following steps:

    1)I took the back up of database in sql server 2000.

    2)Restored the database in Sql server 2005.

    3)CHANGE THE COMPATIBLITY LEVEL TO 90

    EXEC sp_dbcmptlevel dbname, 90;

    4)RUN SP_UPDATESTASTS

    use dbname

    EXEC sp_updatestats

    5)RECOMPILE ALL objects

    Select 'sp_recompile '+name+ ' ' from sysobjects

    (This select stmt reuturn all the objects in the database.I recompiled all the objects)

    But still I am getting some wrong results when I am executing some procedueres and functions.

    Please guide me to how to Migrate Sql server 2000 database to Sql server 2005.

    Thanks in advance

    Regards,

    Sriram Satish

  • May 15, 2008 at 8:39 am

    #815920

    When migrating from SQL Server 2000 to 2005 there can be some issues relating to schema.So please check the objects that contain any schemas other than the default one.:)

  • May 15, 2008 at 9:21 am

    #815977

    Perhaps you could explain what the wrong results are?

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

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