Upgrade from VC 2.0.1 to 2.5

[Harpstein]

Couple of questions:

1) When doing this upgrade do I need to do the database upgrade? I'm not prompted for it during the install and when I try to run it manually it says that I'm on the wrong version to update it.

2) Everytime I run the install, even if I say to keep all my old stuff, I get duplicate tables in the database and when I open VC afterwords all my stuff is gone. I've set my DB permissions according to the documentation.

Thanks in advance!

Tim

[mike_laspina]

Hi,

1) Yes you must upgrade the DB. Do not run it manually. Let the upgrade process do it. Make sure you backup the DB first.

2) Can you expand on this one, I'm not sure what you mean?

[Harpstein]

1) The database upgrade will not kick off during the install. The only box I'm able to check is at the very end of the install to start VC. I've restored the db a dozen times from backup because this has failed so many times.

2) Once I have run the install then look in the VC_database in SQL each one of the VPX_* tables has a duplicate. The duplicates are empty and the originals have all my VC data. When I open VC at this point, all my hosts, clusters, etc are gone.

[mike_laspina]

What does your VC ODBC entry point to?

What version of SQL Server is it?

Restore the DB to a new DB and create a new ODBC entry for it and select it during the upgrade.

[rpartmann]

Hi,

which database Server are you using: MSDE or MS SQL Express?

If you are using MSDE you have to upgrade your Database Server.

a.) http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

b.) http://www.sqlmag.com/Articles/Index.cfm?ArticleID=49316&DisplayTab=Article

Then the VC-upgrade-process will update your DB-schema.

But before the VC_upgrade create another ODBS System DSN (SQL NATIVE Client) to you already existing VC-Database.

I had to use the "sa" account with VC-2.5-upgrade-1 during the upgrade process, because every other use had not enough rights.

hope that helps you move on a bit,

Reinhard.

ps: Award points if you find answers helpful. Thanks.

[Harpstein]

I'm running SQL 2000 sp4. I'll try restoring to a new DB and creating a new DSN and see if that gets me anywhere and let you know.

[Harpstein]

Ok...so the database user needs to have db_owner access to the master database as well as the VC database. Then it magically kicks off the database upgrade during the install. Thanks for all your guys' help!!