The INSERT SELECT is probably your best choice. You might find it easier if you explicitly list the columns instead of relying on SQL Server to guess.

>> I am having problems with the constraints on the ident field and others.

You'll have to provide a little more info.

-Mike