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