Moving the Virtual Center Database from SQL 2005 Express to SQL 2005 server

[lgsiang1]

Hi All,

Anyone have a clear step on how to migrate VCMS database from SQL 2005 Express to SQL 2005 server?

Thanks.

[Troy_Clavell]

Maybe this KB, http://kb.vmware.com/kb/7960893 , will be useful?

[bbambrick]

Found this today while searching for info on the same thing: http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=55

[Mark_Bradley]

Also worth checking out - Microsoft SQL Server Management Studio Express ()

Are you moving the database to a different server? If so, this will allow you to make a backup of the SQL Express database, this can be restored to a SQL server if this is on a seperate server.

__________________________________________________________________________________________

Check out my blog at

[Rohail2004]

this is the best and easiest way to upgrade.

1. Take a backup of the VC server. If you have VC running as a Virtual Machine, it's best to take a snapshot of it so that you have a nice clean restore point in case anything goes wrong.

2. Shutdown any VMware services that may be using the SQL Express database. For instance, the License service, VC service, or Update Manager.

3. Start the SQL Installer with an argument of SKUUPGRADE=1 (e.g. setup.exe SKUUPGRADE=1) for more information about using this command argument, have a look here .

4. When you reach the point where the installer asks if you wish to upgrade the default instance or a named instance, select named instance. Then browse to the instance named "SQLEXP_VIM" Then you can just accept the defaults for the installation.