Determining # records in database

 

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

Parents
  • Former Member
    Former Member $organization

    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



    [edited by: Levi Sauerbrei at 11:25 AM (GMT -6) on 23 Jan 2014]
Reply
  • Former Member
    Former Member $organization

    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



    [edited by: Levi Sauerbrei at 11:25 AM (GMT -6) on 23 Jan 2014]
Children
No Data