VMware Cloud Community
TheSMO
Contributor
Contributor
Jump to solution

Migration vCenter DB from SQL 2005 to Oracle

Hi all,

I'm studying if the migration of the vCenter DB from SQL 2005 Standard to Oracle is possible.

I have already read a lot of documentation and didn't find any clue about this purpose.

Did anyone make it? Is it possible and functionnal?

Thanks in advance.

Reply
0 Kudos
1 Solution

Accepted Solutions
AureusStone
Expert
Expert
Jump to solution

Hi,

There is a thread on the main page with the same question.

http://communities.vmware.com/thread/308260?tstart=0

So yeah it is possible.  But I would recommend starting from a fresh vCenter install.  Either by manually moving your hosts across and recreating your folders/resource pools etc or by using a PowerCLI script.  This way you will not end up with a corrupt schema.

View solution in original post

Reply
0 Kudos
4 Replies
idle-jam
Immortal
Immortal
Jump to solution

this is probably closest you can get: http://communities.vmware.com/message/1726761 if you do not mind losing your performance stats, it's much easier to setup fresh ..

AureusStone
Expert
Expert
Jump to solution

Hi,

There is a thread on the main page with the same question.

http://communities.vmware.com/thread/308260?tstart=0

So yeah it is possible.  But I would recommend starting from a fresh vCenter install.  Either by manually moving your hosts across and recreating your folders/resource pools etc or by using a PowerCLI script.  This way you will not end up with a corrupt schema.

Reply
0 Kudos
bulletprooffool
Champion
Champion
Jump to solution

I'm never a fan of migrating Databases - wherever possible, I just build a new one and migrate configs by scripts (e.g. resource Pools etc)

You will lose historic performance data - so it is up to you whether this is worth the pain of attempting a 'migration'

One day I will virtualise myself . . .
TheSMO
Contributor
Contributor
Jump to solution

Thank you for your awesmone and quick answer.

To my eyes, considering all your points of view. I have two possibilities :

Staying with my SQL Server DB, or creating a new one based on Oracle while we'll change our vCenter version (fresh install).

Reply
0 Kudos