| Vinayak Tadas [MS] 2004-04-15, 4:56 pm |
| One thing you can try for upgrading the databases is
1. back up your existing databases and restore them on another sql server.
2. Upgrade these databases using the CS2002 migration tool and the using the
connection string option
3. Test that the upgrade is successful.
4. Upgrade the Web server and point the connetion strings to the upgraded
servers
For the datawarehouse upgrade the upgrade does not happen in place. The data
from the current database is moved and upgraded to another databadse which
you have to specify. After the upgrade you then have to change the
connection string of the DW resource to point to the upgraded database
Thanks
Vinayak Tadas
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks
"Greg Burton" <anonymous@discussions.microsoft.com> wrote in message
news:C1C0CD1F-CE02-4BE4-AB75-E47336357844@microsoft.com...
> I'm looking for a quickest way to upgrade from CS2K to CS2K2 with minimal
downtime. Speciifically, can I perform the data warehouse upgrade off-line
after the overall upgrade?
>
> Thanks.
>
> Greg
|