How to migrate the vCenter database to Microsoft SQL Server 2008

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.