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, 6 February 2010
How to migrate the vCenter database to Microsoft SQL Server 2008
Trackbacks
Social comments and analytics for this post
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
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
Weblog: uberVU - social comments
Tracked: Feb 06, 18:43
Tracked: Feb 06, 18:43
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