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 |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2003-01-07 : 10:10:03
|
| salute.Is the "Import and Export Data" wizard safe to move from SQL Server 7.0 to SQL Server 2000?I used it and it moved everything successfully!. I chose to move ALL OBJECTS.Well..can I rest assured that everything went ok?..nothing slipped?how can I check?..Thanks In Advance |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-07 : 10:14:31
|
| Safe? I would say yeah. I've used it myself a number of times whenever I need to move a whole database. If anything it copied over MORE than I needed (logins, etc.) It might be better to do it from the SQL 2000 side as an import, rather than an export from 7.0.You could also try detaching the 7.0 database and attaching it in 2000. You'd need to handle logins manually, but it's pretty easy. |
 |
|
|
|
|
|
Is this Wizard SAFE?