Internal Errigal Collaboration Wiki

User Tools

Site Tools

Trace:
Writing /app/www/public/data/meta/databaseandnetworkmanagement/compare_database_schema_pre_post_release.meta failed
databaseandnetworkmanagement:compare_database_schema_pre_post_release

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
databaseandnetworkmanagement:compare_database_schema_pre_post_release [2016/10/05 14:56] – created mmccdatabaseandnetworkmanagement:compare_database_schema_pre_post_release [2021/06/25 10:09] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +====== Compare database schema pre/post release ======
  
 +Author: Colum Foskin
 +
 +
 +===== Initial Setup Steps =====
 +
 +  * The first thing to do is to find out where to source the correct database schema - for pre and post release (Ask a dev to clarify this)
 +
 +  * Dump the databases for each application - Ensure to use the flag --no-data 
 +<code>mysqldump -u root -p --no-data "database" > "dump file name" </code>
 +
 +  * Do this on each server for pre/post comparison
 +
 +  * Use ftp to take them down to your local machine:
 +       *  Ftp: sftp "server name" and navigate to the dir and use "get dump file name"
 +
 +  * Create 2 databases for each application locally:
 +       *  eg. Ticketer, create the ticketer_before && ticketer_after databases
 +
 +  * Important! before you proceed ensure that you have a ticketer and an snmp manager database locally - these are not used for the comparing, but to ensure no errors when loading the databases. 
 +
 +  * If you do not have them then you will need to create them (the dump files will reference ticket.table and snmp_manager.table and your created ones will have different names so you will have errors)
 +
 +  * Then load the database dump file for each application to your created databases for before and after release eg:
 +       *  For ticketer: ''mysql -u root -p ticketer_before < ticketer_before_dump.sql''
 +
 +  * Bring up the database for each application on both the before and after, then do a show tables to be sure the tables have loaded correctly locally (verify tables are correct)
 +
 +----
 +
 +===== Install DB Solo =====
 +
 +  * Install the application DBSOLO to do the comparing - the scrum laptop has it installed if needed (and mysql)
 +       *  Set up your connection to local dbs
 +       *  Click tools -> compare schema -> on the src select your before schema, on the dest click you after schema
 +       *  Click next until compare is done
 +       *  Click the icon under the src window to show sql script which would update the old schema with the new one and save to file.
 +       *  Repeat for each of the 4 applications, these are your scripts!

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki