Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2004-02-16 : 05:22:26
|
| I have a database on SQL server 7 desktop edition. I want to transfer it wholly to a SQL server 2000 box. I thought I would be able to detach it and attach it to the 2k server however the option is greyed out on the desktop edition, is this a feature of sql server 2000 only. Do I have to DTS the database over or is there a quicker way?My second question is can I simply upgrade the desktop edition to the SQL server 2k Personal edition and will this allow me to then attach and detachthankssteveSteve no function beer well without |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-16 : 06:20:38
|
| You can back up the database then restore it - it's much safer than a detach/attach==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-02-16 : 09:33:21
|
| Thanks I'll try thatsteveSteve no function beer well without |
|
|
|
|
|
|
Copy cat