Hello:
You can reference my other posting, where I mention that my test GP 2013 R2 upgrade is failing for one out of sixteen databases, simply because a handful of fixed assets tables refuse to upgrade from GP 2010.
Here's the SQL help that I need.
I have backed up the data in those fixed assets tables into "backup" tables.
I can drop these fixed assets tables. And, I can recreate the tables, based on scripting that I created from other fixed assets tables in corresponding databases that successfully upgraded.
But, I cannot copy that data from the backup tables into these recreated GP 2013 tables because the GP 2013 tables have more columns in them than the GP 2010 tables have.
For example, the FA15000 table in GP 2010 has 11 columns, while the corresponding GP 2013 version of this table has 21 columns.
So, how do I copy the data from these backup tables into these new tables, so that GP Utilities will proceed with the upgrade?
Any ideas would be very much appreciated! If I don't hurry along with this test upgrade, I'm going to get behind schedule.
Thanks!
John
*This post is locked for comments