If you want to relocate your vCenter database from a local express SQL server to a central Microsoft SQL Server 2008, you can use the SQL Server Import and Export Wizard to copy and transform data between supported data sources and destinations.
The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead.
I’ve created a little Jing movie which demos the migration from a local SQL express database to a central Microsoft SQL Server 2008.
Saturday, February 6. 2010
How to migrate the vCenter database to Microsoft SQL Server 2008
Comments
Display comments as
(Linear | Threaded)
Don't forget to create the SQL agent rollup jobs after migrating from SQL Express.
These jobs provide historical performance data for the past day,week,month,year reports.
If these jobs are forgotten you can only view performance data for the last 24hrs.
If you use SQL Express this is managed by vCenter, but if you use the full SQL product, this task is offloaded to the SQL agent.
So make sure the SQL agent service is running and the jobs are loaded.
You can find the jobs in C:\Program Files\VMware\Infrastructure\VirtualCenter Server\
Look for the following .sql files
job_schedule1_mssql.sql
job_schedule2_mssql.sql
job_schedule3_mssql.sql
#1
Arnim van Lieshout
(Homepage)
on
2010-02-10 10:26
(Reply)
In this KB article, you'll find the steps to recover the SQL agent rollup jobs: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004382
#1.1
Arne Fokkema
(Homepage)
on
2010-02-25 15:19
(Reply)
This post was mentioned on Twitter by bjornbats: RT @esloof: How to migrate the vCenter database to Microsoft SQL Server 2008- http://bit.ly/bOnFEO
Tracked: Feb 06, 18:43