• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 43 views
  • Users 0 members are here
Related

Determining # records in database

Barbara Pinney
$organization

 

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
  • $organization

    Thank you Levi!

     

    Barbara

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Thursday, January 23, 2014 11:30 AM
    To: Barbara Pinney
    Subject: Re: [Tessitura Technical Forum] Determining # records in database

     

    Barbara,

    I would suggest running the NCOA Processing utilityin 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 accurate 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

    From: Barbara Pinney <bounce-barbarapinney3568@tessituranetwork.com>
    Sent: 1/23/2014 11:14:13 AM

     

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    Thank you Levi!

     

    Barbara

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Thursday, January 23, 2014 11:30 AM
    To: Barbara Pinney
    Subject: Re: [Tessitura Technical Forum] Determining # records in database

     

    Barbara,

    I would suggest running the NCOA Processing utilityin 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 accurate 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

    From: Barbara Pinney <bounce-barbarapinney3568@tessituranetwork.com>
    Sent: 1/23/2014 11:14:13 AM

     

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data