Coverting MSDE VC Database to SQL 2005

[piercelynch]

Afternoon all,

I have an old installation of VC 2.5 which is still using MSDE, with the old configuration in the 'master' DB.

Basically, I wish to export the master DB onto a new VC machine using SQL 2005. However, before I started playing - wondered if anyone had any best practices to doing this?

Thanks in advance.

P.

[Effective]

This maybe doesn't sound so good advise on the short term, but I think on the longrun it would be better to just start from scratch.

Create a new Virtual Center
Disable Vmware HA & DRS functionality in the old VC
Add all ESX servers to the new VC
Create the right cluster configs in the new VC
Set permissions
...

Probably when you have an MSDE as database your environment isn't so big, and it's much less work then migrating this MSDE, specially with all tables in the master DB.

Regards,

K.

[HyperSprite]

+1 on Effective's thoughts.

[Troy_Clavell]

I agree with the other posters... Also, I believe an upgrade from MSDE to SQL 2005 Standard is not supported, by Microsoft. You can go from MSDE to SQL Express, but what is that really buying you?

A clean install seems to be the best bet for your scenario.

[Effective]

I kind of went down this road once : upgrading MSDE to SQL2005 Express and then installing a second instance of SQL 2005 Standard, mounting the DB files and then repointing the DSN, but well, so much trouble no thanks, from now on just scratch the surface and build again, ... much easier ....

K.

[piercelynch]

Think you guys might be right there, which is what I thought really.

Thanks for the input, most appreciated.

P.

[Troy_Clavell]

glad we could be of assitance.... Can you mark the thread as answered if you feel as though it is?

[piercelynch]

Apologies - I thought I did, but appears I didn't! My bad!

P.

[Troy_Clavell]

One thing I did find, if you are willing, you might want to give the below link a try

http://vmware-land.com/Vmware_Tips.html#VC7