Convert Database from Oracle to SQL

[Bartman71]

Hi,

is there any way to convert/move the VCenter database from Oracle to SQL?

Marc

[rossb2b]

SQL server has methods of importing data from a variety of sources including Oracle. I have never gone it this direction but it should work.

[azn2kew]

What version of SQL/Oracle are you running for VC server? You can migrate Oracle to SQL 2000 but should be similiar to SQL 2005.

If you found this information useful, please consider awarding points for "Correct" or "Helpful". Thanks!!!

Regards,

Stefan Nguyen

iGeek Systems LLC.

VMware, Citrix, Microsoft Consultant

[azn2kew]

You can play with live lab how to migrate oracle/sql here before you want to test it live.

If you found this information useful, please consider awarding points for "Correct" or "Helpful". Thanks!!!

Regards,

Stefan Nguyen

iGeek Systems LLC.

VMware, Citrix, Microsoft Consultant

[RParker]

I am curious, why do you want to switch from oracle to SQL? Are you having performance issues? I am just wondering why the switch, perhaps you could she some light on issues you are having?

[odonnellj]

Well, I can tell you why I'm looking at moving to mssql and it's not because I like the product. After 4 years of using Oracle and VC, the new VC 2.5 install we have has serious problems and Support has done little to fix them. After almost two months of back and forth they finally admit to some Oracle package errors but it's still not resolved - database growth is still rapidly growing.

http://communities.vmware.com/thread/124035

[Bartman71]

We are running VCenter 2.0X at the moment on Oracle. We are planning to go to Vcenter 2.5 in the near furture. Currently the Oracle Servers are running Production Databases and the VCenter Database on physical machines. They will also be virtualised. We also have a very good perfroming SQL 2005 Server running on 64Bit virtualised environment which does not have as much load as the Oracle PRDE Database. So the idea was to offload the Vcenter load from Oracle to SQL while moving Oracle to the next version and virtualisation step.

I will check out the SQL import fuctions and see where the ends up with. I though there might be a recommended VMWare way of either do it this way or never ever migrate....

Marc