by Jonathan Wareha » Fri, 19 Apr 2002 18:40:21
I am upgrading databases from 6.5 to 2000 (different servers) using the
upgrade wizard and I want to prevent users from logging into the 6.5 server.
Can I set the databases to single user or will this prevent the upgrade
wizard from executing properly?
Thanks,
Jonathan
by Anith Se » Fri, 19 Apr 2002 22:38:35
Quote:> Hi,
> I am upgrading databases from 6.5 to 2000 (different servers) using the
> upgrade wizard and I want to prevent users from logging into the 6.5
server.
> Can I set the databases to single user or will this prevent the upgrade
> wizard from executing properly?
> Thanks,
> Jonathan
1. SQL Upgrade 6.5 --> 2000, scheduled tasks not transferred
Hi,
Using the SQL Server upgrade wizard to upgrade a 6.5 database to a SQL
2000 database ( same computer , named pipes upgrade ), we do not get
an option to transfer SQL executive settings.
On the system configuration screen of the SQL server upgrade wizard,
the SQL executive settings option is greyed out.
I suspected it was due to the SQL executive/Server Agent not being set
to auto-start. However even with this I still get the greyed out
option in the upgrade wizard.
Any ideas?
Thanks in advance
David.
3. Upgrading SQL 6.5 -> SQL 2000
4. Connecting to remote SQL2000 server from an ICS client??
6. Getting the whole SQL text of the DB
7. Upgrade 6.5 -> SQL 2000 cluster
9. Problems with Upgrade wizard 6.5 > 2000
10. upgrade from 6.5 -> 2000 failed
12. SQL 6.5=>2000 Upgrade: ?Lint like tool for identifying potentially problematic
13. problems upgrading 6->7->2000