Tuesday, February 14, 2012

converting SQL 2000 data into a SQL 2005 server

I have a large (huge) database that I want to copy onto my new slq 2005 test server. I'm leaning toward detaching the data on my 2000 box, duplicating it, copying it to my new 2005 machine, and attaching it. Is it possible that it could be that simple? If not, how is it done? Thanks a bunch for any help or pointers to the articles I was totally unable to find on the subject.
Yes, it should be that simple. Use sp_detach_db and sp_attach_db; check BOL for details if you need them.|||

Thanks Paul! I appreciate the confirmation that I was on the right track. I did stumble across and article I found useful at...

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

Also, I had no idea where the sql server Management Studio was or how to install it. Finally I put in the sql server 2005 install cd, and chose client tools. It intalled and now I can use it to reattach the database.

Best wishes

No comments:

Post a Comment