Post reply

import and export wizard

  • July 15, 2008 at 12:16 am

    #124681

    hi,

    when i am importing data tables and procedures from sql server 2005(9.0 RTM) to sql server 2000 i found an error.

    i cannot able to import data from 2005 to 2000 using import and export wizard 2000.

    please help me in this regard.

    thank you

    venugopal reddy

  • July 15, 2008 at 1:34 am

    #842859

    Hi,

    First of all you will do a full backup of you db or make a copy of your db as you want!

    than try to change the compatibility level from 90 ot 80

    Compatibility level 90 is for SQL Server 2005 and 80 is for SQL Server 2000 after that try to export data from!

    Don't forget to make a copy or full backup of you database!

    use this to make compatibility changes:

    USE [master]

    GO

    EXEC dbo.sp_dbcmptlevel @dbname=N'your_database_name', @new_cmptlevel=80

    GO

    Then try the export!

    Let me know does it work or not!

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

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

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