Starting with an Existing Database

If you have existing application database schema that you want Datical DB to manage, the following outlines the process to implement Datical DB.

To start using Datical DB to manage database changes across the SDLC, a simple process is required.

This is an optional, one-time process to ensure databases are in sync:

• Create a Datical DB "Deployment Plan" with connections to the databases to be managed
• Baseline the first database (DEV/CI). This needs to be the original or best configured – your reference database.
• For each additional database (TEST & PROD)
  • Compare databases to ensure the application schema are in sync
  • Resolve any differences
  • Perform a ChangeLog Sync to get each setup for Datical DB management
    
     
    

Datical DB then creates an initial model "ChangeLog" from one of the existing databases and creates a metadata table in each database named "DATABASECHANGELOG" that will be used to track the state. Now the databases look like this:

 
Note: The Datical DB model and Metadata table illustration above is a representation of an actual model.