>I don't see how any form of backup woyuld work, as the PKXFER and PKWarehouse will have the 2 additional columns in them. The only way I can see doing this is to SELECT INTO on each table.
>
>
It was not the only Backup suggestion - you can use SSIS (looks like it may be your best bet here), you can use script tables (with data), etc.
If it's not broken, fix it until it is.
My Blog