You cannot copy individual columns from one table to another existing table by using Transact-SQL statements. However, you can create a new table in the default filegroup and inserts the resulting ...

The ESF Database Migration Toolkit provides an easy to follow wizard that allows you to migrate databases from one format to another in three steps.