12-10-2007, 05:40 PM
|
#3 (permalink)
|
| Eskimo Man Join Date: May 2006 Location: Fairbanks, Alaska
Posts: 643
Rep Power: 0  | Are ALL of your records going to their foundation? If so, it'd be even easier to just copy the database file... If not all records, you could copy the database file to a temporary machine, and delete all of the information that doesn't get passed on to them (for example, if you're using constituent codes to identify constituents across organizations, globally delete all constituents without the appropriate constituent codes).
I realize this kind of forces them into your system, but they could take what you give them and modify at their will, and have a much cleaner starting point then trying to import all that information into a clean database...
Just another idea...
Doug
__________________ ~~~~~~~~~~~~~~~~~~~
Doug Creek 
RE Database Administrator
University of Alaska Foundation sndgc@email.alaska.edu |