I tried searching here for a similar solution but didn't see one so I was wondering what is the best way to accomplish the following.
I have a table with 17 million + rows all have a unique ID. We have recently created a new table that will be used in conjunction with the previous table where the foreign key of the new table is the unique id of the old table.
For ex.
Table 1 - id, field1, field2, field3...
table 2 - table1.id, field1 ...
The problem is since we are migrating this into a live environment, we need to back fill table 2 with a row containing the id from table 1 for each row in table 1. ex, table 1 - 1, test, null table 2 now needs to have: 1, null, ... and so on for each row that is in table1. The main issue is that the ids are not all sequential in table 1 so we will have to read from table 1 and then insert based of the id of found into table 2.
Is there any easier way to go about this? Thanks in advance Joe
Also to clarify, table 2 will be new data and the only thing that it will contain from table 1 is the id to keep the foreign key relationship
Also this is sql server 2000