Wednesday, March 24, 2010
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.
Click here for Video --> "How to migrate the vCenter database to Microsoft SQL Server 2008"