Post reply

Tips and Provisions for Migrating Data from SQL 2000 to 2005 to 2008

  • October 14, 2010 at 2:28 am

    #228053

    Hi All,

    Request you to provide the steps and tips and provisions for Database Migration from SQL 2000 to 2005 to 2008.

    Thanks

  • October 14, 2010 at 4:14 am

    #1236715

    Good place to start for migration project in below link, hope your it answer's your question

    http://www.sqlservercentral.com/articles/Upgrade/65872/

    Cheers

    Sat

    Cheer Satish 🙂

  • October 14, 2010 at 11:58 am

    #1237122

    See also this link:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

    SQL-2008 Post-Upgrade Tasks - Upgrading to SQL Server 2008

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

    1.Change the db compatibility level to 100.

    2.(ONLY for database upgrades from SQL Server 2000 to SQL Server 2005/2008)

    Execute DBCC CHECKDB WITH DATA_PURITY to check the database for column values that are not valid or are out of range.

    After you have successfully run DBCC CHECKDB WITH DATA_PURITY against an upgraded database,

    you do not need to specify the DATA_PURITY option again because SQL Server will automatically maintain "data purity."

    This is the only DBCC CHECKDB check that you need to run as a post-upgrade task.

    DBCC CHECKDB ('[dbName]') WITH DATA_PURITY;

    3.Run DBCC UPDATEUSAGE to correct any incorrect page or row counts.

    USE dbName;

    go

    DBCC UPDATEUSAGE (dbName);

    GO

    4.Update statistics by using the sp_updatestats stored procedure to ensure all statistics are up-to-date:

    USE dbName;

    go

    EXEC sp_updatestats;

    go

    5.Ensure PAGE_VERIFY is set to CHECKSUM (not TORN_PAGE_DETECTION) on the database:

    Microsoft best practice recommendation: http://technet.microsoft.com/en-us/library/bb402873.aspx

    If not set to CHECKSUM run the following on the database:

    ALTER DATABASE [dbName] set PAGE_VERIFY CHECKSUM;

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

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

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