How move only some records from one table to another

[data808]

I made mistake by uploading the backend file with an older version and now only yesterday's records are missing. I got lucky and was able to get a restore copy of the file that shows all of yesterday's records. However, the current backend file is live and users have already begun to save new records this morning.



Is there an easy way to append only yesterday's records from the restore file to the current backend file? I also notice that the records being created today have already been given primary key numbers that have already been used for yesterday's records which will make it more complicated to have it create new primary keys for each of these records being appended.

Any help or suggestions are appreciated.

Thanks.

[Welshgasman]

Primary keys would not be a problem, as you cannot upload those. Where you will get an issue is for any linked records with those keys.
Plus if you have any logic that relies on pk > a certain pk, then that is going to cause issues, as yesterdays will be greater than todays.
Best not rush into it with a knee jerk reaction. Take your time in fixing it.

[data808]

Thanks for the reply. Yes I was able to append the records as long as I don't include the PK data like you mentioned. I setup a test environment just to make sure everything looked ok.

So now its just a matter of waiting till the end of the day and apply this process when everyone is logged off. Thanks again for you help on this.