Historical Payroll data deleted

[jymm]

Hopefully everyone remembers the dark days when you had to create hitorical payroll companies so that you could get the payroll data out of previous years. Well those back-ups finally paid off. Some time between when I created the 2000 backup in January of 2001 and the 2001 backup in January of 2002 someone went in and deleted a BUNCH of old staff members. Only reason that we are noticing it now is that when we went to GP 7.5 then 8, the payroll folks could get the information without going to the historical companies... and of course today a person who worked back in 2001 wants some of historical info.

Here is the question:
by my count there are now 62 occurances of 'EMPLOYID' in the 8.0 database. Anyone ever have to copy a bunch of records from one payroll database to another (keeping in mind that the backup is a historical 7.5 db)? I can easily figure out which EMPLOYID I want (which are missing), but with 62 tables I am not sure which to take and in which order without a fair amount of trial and error.

aside from hommicide involving the payroll clerk that probably did this (they are gone now) anyone got any ideas?

 

[stef315]

Why would you have to copy into the live company? Can't the information be gathered from the historical company? You would either have to install 7.5 to restore the database to, restore the database and upgrade to 8, or just restore it and gather the needed data from SQL if easy enough.

Most of the time I create these archive companies as actual companies in GP that only users who really need it have access to. This was for those payroll historical companies and for clients who just want to remove history out of their live company. That way the companies continue to get upgraded with the live company.

 

[jymm]

well - the live company has all of the data for EVERYONE (except those few people that were deleted) and because of changes in 7.5 (or was in 7.0?) you do not need the historical payroll companies anymore. You can get the information for historical years from the live database.

SO - if I could copy the data (for just those few people that were deleted) from the database that we created back in '01 then all historical information would be correct.

I guess the question still stands (and sounds like I need to touch base with MBS) about being able to copy all of the data for selected people from one db to another.