I'm investigating address hygiene services and I'm not sure how to determine how many records are in our database.
Any suggestions? I do not know SQL.
Thanks.
Barbara Pinney
Tulsa Arts Management Consortium
Barbara,
I would suggest running the NCOA Processing utility in Export mode. This should produce a summary report that tells you how many addresses are included in the file. This will give you a much more accurate idea of what your costs will be than you would get if you simply counted the number of active constituents or the number of active addresses. It will also give you a head start when the time comes to actually do the updates.
I'd spend some time reading through the documentation on the NCOA Processing utility before you dive in. But it should give you the information you are looking for.
- Levi