I have an old SQL 6.5 database that is still in use, and we want to upgrade it to SQL 2000. I was planning to test it using the Upgrade Wizard, but wondered if after I did this would the SQL 6.5 database be available to the user? I just want to test the upgrade and application first.
I'm planning to put it on a multi-use SQL 2000 server. Are there any considerations I need to think about before I try the upgrade? Unfortunately, my SQL 6.5 experience is very limited, so any recommendations are really appreciated.