I run an database for my department. It currently gets data from 3 sources; User input and 2 remote systems. one of the remote systems that updates the static data; names, address, dob etc. will be going down for a period of time (few months).

The static data is available from another yet system but not one we can immediately interface with.

What's the best way to go about managing the gap in static data? I come up with a blank after thinking manual entry

Export the data from the secondary system as flatfiles, if possible.

Do you need to manage the gap in static data? What are the consequences and does anyone care about them from a business perspective?

One of the things that we as geeks often miss is that the business knows there will be a gap and doesn't really care.

-PatP