If all columns are defined in both tables and all columns have default values, here is a possible solution.

Microsoft has a package for backwards compatibility with 2005, I think the...