Post reply

i would like to attach database from 2005 to 2000 sql is there any wayout

  • July 22, 2008 at 11:20 pm

    #123238

    i would like to attach database from 2005 to 2000 sql is there any wayout

  • July 22, 2008 at 11:22 pm

    #846800

    Use attach and detach method..

    simple...:)

    Cheers!

    Sandy.

    --

  • July 22, 2008 at 11:30 pm

    #846804

    [font="Verdana"]You wont be able to degrade the version of database (i.e SQL 2005 to SQL2000) either by detach\attach or backup\restore method.

    But you can script the entire database and execute the script in SQL 2000. Check out the link below.

    Moving SQL2005 db to SQL2000 db[/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • July 22, 2008 at 11:33 pm

    #846806

    Can't be done. There is no way to downgrade a database from SQL 2005 to SQL 2000. That holds true for all the versions. The internal structure of the data file is too different.

    The first time you restore/attach a DB from a lower version to SQL 2005, the internal structure of the database is converted to the 2005 format. There is no command, documented or undocumented that will undo that upgrade, and SQL 2000 cannot understand the SQL 2005 data file structure

    Your only option is to script out the database and bcp out the data then run the script on the SQL 2000 server and finally load the data

    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 22, 2008 at 11:45 pm

    #846809

    gail,

    you are correct, I said in sql 2000 and I skiped the question from 2005 to sql 2000...

    Thanks gail for correct me...:)

    Cheers!

    Sandy.

    --

  • July 22, 2008 at 11:47 pm

    #846810

    Sandy (7/22/2008)

    Use attach and detach method..

    simple...:)

    Cheers!

    Sandy.

    Can you please check your facts before posting in the future? Thanks.

    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 22, 2008 at 11:48 pm

    #846811

    gail,

    I already said in the above post, I just skiped the question....:)

    apology for this..:)

    Cheers!

    Sandy

    --

  • July 23, 2008 at 4:13 am

    #846890

    I know that as per my Knowledge that we cannot have software Upward compitibility but there might be some wayout we should look for that.

    😎

  • July 23, 2008 at 4:24 am

    #846895

    Gail Shaw

    Thanks for your Qucik reply i think i will be lot benifited if continue be in conversation with u

    akhtar195@aol.com

Viewing 9 posts - 1 through 8 (of 8 total)

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