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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2004-07-07 : 06:39:42
|
| Hi there,I have a windows2k box running SQL 7 with around 150 databases on there with different users for each database. I need to move these databases and users to a win2003 box running sql 2000. What is the fastest way possible to move? db detatch/attach? restore?Any pointers appreciated.thanks - matt |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-07-07 : 07:09:22
|
| yup...db detatch/attach + script to re-install/transfer/copy the users....search here for the latter..there's a working example somewhere...(maybe on nr's home site) |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
|
|
|
migrate databases from SQL 7 to SQL 2000