Comments
Sort by recent activity
Thank you for your reply Eddie but this does not solve my issue. I'll try to explain my issue more clearly. The following example uses the "Item" table which has a primary key on the ID column We have: db1.Item.ID = 1 to 10 db2.Item.ID = 1 to 10 db1 and db2 records are in no way related, they just happen to have the same PK value in two separate systems and respective databases. In the end, I need to append the rows together like the following: db1.Item.ID 1 <-- from db1 (and all of the other rows currently in the db1.Item table) ... 10 <-- last row in db1.Item 11 <-- this would be row 1 from db2.Item table ... 20 <-- last row in db2.Item Even though the two Item tables have the same structure, the rows in each do not relate to each other and in the end I need to have all of the rows in the same Item table. Of course this a simplified example, there are many tables involved. / comments
Thank you for your reply Eddie but this does not solve my issue. I'll try to explain my issue more clearly. The following example uses the "Item" table which has a primary key on the ID columnWe h...