There are several databases on development and live servers. Here is the information about the important ones

Live

iriserve_topazport01 - This is the live database.

iriserve_tbo2 - This is the live database for TBO

iriserve_scramble - This is a scratch database that is used for creating our sanitized database.

iriserve_sugarcrm - The database used for our install of Sugar

Development

irisdev_sandbox2 - The database used by staging/devcur

irisdev_thenetworksb - The database used by staging/trunk

Database Update Scripts

On Iriserve in the davidmck directory, there are a set of scripts to update various databases. Hopefully the naming convention makes it clear which script does which things.

update_thenetworksbdb.sh - Updates the database used by staging/trunk on irisdev.

update_sandboxdb2.sh - Updates the database used by staging/devcur on irisdev.

update_scramble.sh - Creates a new version of the devtransfer.sql.gz by dumping the current database and altering the contents of the database.