Database Continuous Integration (CI) tools in Valentina Studio Pro applies good software development practices to databases.
Database Continuous Integration
Valentina Studio Pro includes several tools for practicing continuous integration for your database projects. While some tools such as SQLDIFF have been a part of Valentina Studio Pro for some time, additional features are now available.
- Schema Snapshot
- Granulate schema representation for tracking changes or using a part of schema
- SQL DIFF
- Compare schemas and produce SQL scripts to transform the first into the second
- Source Control
- Evaluate, commit and migrate database schema
While CI doesn't remove bugs, it makes it much easier to resolve if you are able to determine if they were introduced after the last integration.The addition of tools to evaluate, commit or if necessary, roll back an integration, much like any other form of software development, is what Database Continous Integration is all about.