Iterate through each row in Table 1 that has not been flagged as processed, create a new record in Table 2 from the data read in Table 1 and flag that row in Table 1 as processed. Table 2 is quite different from Table 2. Need to read in the last record from Table 2 to create the new record that goes into Table 2. Can be done using any method that will work properly, including stored procedures, java, or whatever.
Sir i am really interested in your project .
sir i am an expert of software and web development. i have already developed many web and windows applications and some are similar to your project . you can check my portfolios and my previous projects . so i can finish you job faster and with best quality at lowest cost . so please feel free for contacting me i am waiting for you response.
I have more than 2 years or working with sql server and designing database schemas. We can talk in more detail about the project. Looking forward to work with you.
Dear You,
I am really interested to work on this project,
I can start the work now , and can provide the best services from my end.
Please come on chat to discuss more about the project.
Thanks!
Hi,
let me assist you in this task. I'm enough experienced in DBs and this can do this quickly.
Could you please tell me a bit more about the tables structure: their columns and datatypes (schema could be the best but not sure if you have it :)
If it is possible I'd like ask you to tell me what DB do you use. Some of them have their own tools to do such a migration easily. Maybe it is your case.
Sincerely,
Sergii