We have a strange scenario.
We have a source database running on SQL Server 2005 where we push data to a target database running on SQL Server 2008 R2.
The source database table has 5 columns. The target database contains an extra column which is not nullable and has a
DEFAULT value defined.
We need to push data for the 5 columns from source to target. If we use any tool like red-gate or dbcompare, it will compare source with destination and provide a query to insert the new data on to the target, however running the query fails as it is not inserting anything into the newly introduced column which is not nullable.
Any idea on how to handle this?