March 21, 2002 at 7:57 am
I have installed SQLServer7 and 2000 in the same server, and I need to move a database to SQLServer2000. How can I do it?
March 21, 2002 at 9:34 am
I believe a detach / attach will work. You can also backup and restore from these two if I remember. Raul Sharma and Brian Knight have articles on this subject on this site.
Steve Jones
March 21, 2002 at 10:35 am
Attach works well. It automatically upgrades the structure of the mdf to the SQL2K format when you attach, so you can't move it back to SQL7 later by detaching again.
Andy
March 21, 2002 at 1:02 pm
what happens to the structure of the .MDF when you do the Restore method of upgrading ?
March 22, 2002 at 4:55 am
Same as attach.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply