Home Forums SQL Server 7,2000 General Is it possible to move database from sql server 2005 to server 2000 ..?? RE: Is it possible to move database from sql server 2005 to server 2000 ..??

  • January 7, 2009 at 11:17 pm

    #923098

    Script the metadata from 2005, apply the scripts on the 2000 server. Then BCP out the data from each of the tables, then BCP them in to SQL 2000.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]