I need to do an upgrade of an SQL 6.5 database to SQL
2000. These servers are on different machines. Ny question
1) If I run the Upgrade Wizard from the SQL2K will my SQL
6.5 db still be functioning? The reason for asking that is
because I want to doa test upgrade first before I do the
final upgrade, so users will still be working with the 6.5
version for a week or so after the test upgrade.
2) Can I detach the database on the SQL 6.5 and copy it
over to another machine with SQL 6.5 installed, attach it
there and mess around with that database rather than
directly with the production database?
3) What is the worst scenario if the upgrade Wizard fails?
Will it impact my SQL 6.5 database?
4) Any recommendations, best practises, step by step
articles? I would really appreciate any of that sort of