datical db

Lower Costs and Reduce Risk.

Increase App Release Throughput.

Achieve Faster Time to Market.

Datical It!

Datical DB

r2@datical.com_BPMark_web_listrdavidson@datical.com_BPMark_web_listDatical DB
Agile Application Schema Management™

IT has raced to adopt agile development, automation and dynamic environments to deliver high quality applications faster, lower costs, and respond to constant change.  They’ve invested in tools and strategic underpinnings — Agile, DevOps, Cloud, Continuous Delivery, Big Data and more.

But, even with these innovations, application teams still scramble to deal with release failures and data loss because little has been done to manage schema change in lock step with application code as part of the Application Release Lifecycle.

Simply put, Agile isn’t Agile when out of process schema changes, drift, manual processes or SQL script errors corrupt critical application releases.  Processes and tools must be knowledgeable of schema and its dependencies – otherwise, applications can never truly deploy continuously until data integrity in production can be ensured.

Datical DB automates, simplifies and manages application schema change for high velocity application releases across any environment, for virtually any database. No agents required.  Eliminate your risk and ensure correct deployment the first time with Datical DB:

  • Eliminate manual change scripting with automatic authoring and break through bottlenecks in your develop-test-deploy release process.
  • Accelerate application releases and automate deployment processes.
  • Forecast how database changes will impact production – before you deploy.
  • Database neutral – works with Oracle, DB2, MySQL, SQL Server, Postgres and more.
  • Update schema ‘with’ application code without dealing with SQL syntax.
  • Stop configuration drift and instantly perform fresh installs in seconds.
  • Works with your existing tools and processes — IBM Rational, BMC BladeLogic, Jenkins, Puppet, Chef, MS TFS, and more.
  • Implementation is fast. No expensive migration project or long services engagement required.
1 baseline


The first step is to generate a baseline schema – the starting data model for defining and versioning your database. Establishing a baseline with database neutral modeling makes it possible to compare multiple databases, compare databases of different types, and transform your applications automatically.

Wizards make generating baseline schema easy. The baseline data model enables Datical DB to compare initial schema with future versions and provide a history of change as your database evolves over time.

2 ddb-changeset-wizard


Instead of writing SQL, use Wizards to create a data model of database neutral changes and define your deployment route from Dev, to QA, Staging or Production based on your unique release process. If you can’t let go of your scripts, simply import them. The important best practice is to treat database changes as Tier 1 artifacts by checking them into your existing source control with your application code.

Datical DB can model an existing database and compare it to other databases to automatically identify and manage differences and dependencies.

Next Deploy
3 forecast


Proactively forecast the impact of database changes in production – or any other environment – before you deploy. No more scrambling to troubleshoot errors at deploy time. No downtime or lost data. Just assurance that changes will not cause unexpected problems in production. No delays. No surprises.

With Datical DB’s Forecast and Reporting, your Mean Time to Innocence is about 10 seconds. That’s the time it takes to prove an error or downtime wasn’t caused by the database or your team. No more finger pointing. No late nights spent searching for the cause of a failed deployment.

4 deploy


Datical DB deploys database schema changes to multiple databases and mixed environments simultaneously — Oracle, DB2, MySQL, SQL Server, Postgres, and more. Datical DB plugs into your existing processes and it works with your existing tools: source control, build systems, testing suites, automated frameworks and more.

Datical DB works with IBM Rational, BMC BladeLogic, Jenkins, Puppet, Chef, Team Foundation Server, and more.
With Datical DB, your code, database, people and processes stay in synch.

5 rollback


Rollback makes it easy to undo select database changes or revert back to the previous version automatically. You can also rollback manually via custom rollback SQL.

With Rollback, if you need to undo a change, you have the control and flexibility to manage the situation the way you want.

Next Manage
6 history


Datical DB provides an automatic audit trail of database schema changes that have been applied over time in each environment. It’s about reducing your risk. Prevent data loss and unauthorized data access by knowing who made changes, when they made them, and why they were made.

Built-in historical tracking and reporting make it easy to quickly look back after a change is made to understand the evolution of the data model at a glance.

7 baseline


Datical DB Snapshots automatically capture the current state of the database at any point in the release process.

Snapshots allow you to see exactly how your database server is configured and what the current state of the database is at a glance, at any point in time.

8 compare


Datical DB’s Compare feature provides visibility into schema differences between environments such as differing data types, missing columns, missing tables, foreign keys, etc.

The Compare feature simplifies and speeds troubleshooting of configuration-related problems.

9 ddb-deployment-plan-status

Current State

Datical DB displays the current state of the database as you deploy changes across different environments, multiple databases and mixed environments.

By always knowing the current state of the database, you’ll see at a glance which changes have been deployed, in real time.

10 ddb-deployment-plan-detailed-status

Detailed Deployment State

Stay on top of your database schema deployments both before and after deployment. Quickly see, in detail, the current state of deployments for each database. Easily view whether each change set has been deployed, needs to be deployed, or won't be deployed (for different contexts or changes tagged for a different database type).

11 ddb-gui

Graphical Console and CLI

Datical DB’s centralized console and graphical user interface makes managing database change an easy, straightforward process. Datical’s ease of use makes it possible for less experienced users to manage the change process – freeing up experts for more strategic projects. A command line interface is also included.

Datical It!
Break through your release roadblocks. Request a demo and see how Datical DB automates and simplifies database change. Request a Demo
Want more information? Contact us today!