Connect to the CIT patron database

Run the password script


Because the database contains more than 7 million records, and you are downloading the data into Excel, you need to download the data in batches


Run the following scripts in sequence to get the data

-update the scripts to just pull the fields needed, not all the fields

-update the mapping such that ALL VARCHAR field mappings are set to varchar(500) to avoid errors


Import the data into the local_protected schema in the Metadb database

-disable batch load


After you load the first table of data, append the additional datasets to the data in this table so that all the data is in one table in Metadb




  • No labels