Migrating from SQL 2000 to SQL2005

• vigour

  Newbie

  Points: 9

  More actions

  August 30, 2008 at 11:30 am

  #382467

  Hi guys. I currently use VB6 and sql2000 to develop my applications. i want to move to sql2005 and am having a hard time migrating my database from 2000 to 2005. i need help on what to do.

  Thanks!!!!!!

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 30, 2008 at 11:53 am

  #865387

  What problems are you having?

  [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]

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  August 30, 2008 at 12:01 pm

  #865388

  Here is the link on how to upgrade using the attach/detach method.

  http://msdn.microsoft.com/en-us/library/ms189625(SQL.90).aspx

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  August 30, 2008 at 3:28 pm

  #865405

  Hopefully you have read about the compatability level in BOL and are taking this into consideration ...

  In the 2005 BOL read

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/4760732b-aa3c-4f07-96ec-ba920476dd69.htm

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  September 2, 2008 at 9:45 am

  #866061

  Hi,

  You can try the following if you already installed SQL Management Studio for 2005 -

  1. Detach the database in SQL 2000

  2. Copy it into c:\xxx\microsoft sql server\MSSQL.1\Data\*.mdb (and) *.ldb

  3. Open the SSMS 2005 and attach the database under the correct server.

  Let me know if you have any problems.

  Leo