VMware Cloud Community
Aloha1990
Contributor
Contributor

Migrate from 4.0 to 4.1 with a existing (external) SQL 2008 Database

Hey Everybody,

we have a environment with 4 ESX 4.0 Hosts and a VCenter Server with a Installed Microsoft SQL 2008 Database. The VCenter Server is 32Bit the Database of course, too. Now we need to update the total environment to 4.1, but we like to use the old VCenter Server as Database-Server for the new 64Bit VCenter Server. Is this possible?

If Yes, how ?

if not, is it easiely possible to migrate the 2008 Database to the new Server with a new Hostname?

greets from Germany

Chris Ritter

0 Kudos
3 Replies
pcerda
Virtuoso
Virtuoso

Hi,

vCenter Server 4.1 is compatible with SQL Server 2008 32 Bits, so you won't have any problem in order to use the old server as Database server for vCenter Server 4.1.

Always remember to make a backup of vCenter Database to make a restore of vCenter if the upgrade process fails.




Regards / Saludos

-


Patricio Cerda !http://www.images.wisestamp.com/linkedin.png!

VMware VCP-410

Join to Virtualizacion en Español group in Likedin

See My Blog

See My Linkedin Profile

-


Si encuentras que esta o cualquier otra respuesta ha sido de utilidad, vótalas. Gracias.

If you find this or any other answer useful please consider awarding points by marking the answer helpful or correct. Thank you.

Regards / Saludos - Patricio Cerda - vExpert 2011 / 2012 / 2013
0 Kudos
Aloha1990
Contributor
Contributor

Hey thanks for the quick help,

so i just need to set up the ODBC drivers on the new system and select the old Database while the installation process? Is that right ?

greets Chris

0 Kudos
pcerda
Virtuoso
Virtuoso

Right!

In the new server with 64-bits OS, you have to create a DSN ODBC pointing to database server (the current server). Then, when you are running the vCenter installation process, you have to use that DSN (this action upgrades the vCenter database schema).

Take a look of vCenter Upgrade Guide in VMware Documentation, specially the Chapter 5 "Upgrade to vCenter Server on a Different Machine and Upgrade the Existing Database"

http://www.vmware.com/pdf/vsphere4/r41/vsp_41_upgrade_guide.pdf




Regards / Saludos

-


Patricio Cerda !http://www.images.wisestamp.com/linkedin.png!

VMware VCP-410

Join to Virtualizacion en Español group in Likedin

See My Blog

See My Linkedin Profile

-


Si encuentras que esta o cualquier otra respuesta ha sido de utilidad, vótalas. Gracias.

If you find this or any other answer useful please consider awarding points by marking the answer helpful or correct. Thank you.

Regards / Saludos - Patricio Cerda - vExpert 2011 / 2012 / 2013