Post reply

Upgrading to 2005

  • July 14, 2008 at 7:53 am

    #129917

    Hi

    I have a project to migrate a SQL2000 database to SQL2005. I want to be able to test our CRM application. What I would like to do is to take a trace of all the logs on the SQL2000 database and then replay them on the new SQL2005 installation.

    Anyone know if this is possible or if there is any software that allows this to be done.

    This is the first of a number of upgrades that we have to do so would find it very useful

  • July 14, 2008 at 8:17 am

    #842408

    Have you tried SQL Profiler?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 14, 2008 at 8:47 am

    #842434

    did you mean do a transaction log backup and apply the same to SQL 2005 Database for a couple of weeks before you make a switch over or, just run a Profiler Trace?

    Well anyway if you decide to migrate:

    1. migrate using Database Backups and Restores.

    2. After the Database is Online on SQL 2005, change the compatibility to 90.

    3. Run DBCC UPDATEUSAGE

    4. check Database consistency using DBCC CHECKDB(dbname)

    somethings to start with.

    Maninder
    www.dbanation.com

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

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