ER/Studio Version 20.3: Enhancements and New Features
ER/Studio continues to evolve, and the latest release, version 20.3, introduces significant updates that streamline data management processes, particularly with the integration of Git repositories. This update brings a suite of powerful features designed to enhance the functionality of ER/Studio, making it even more indispensable for data professionals. Here’s a closer look at what’s new in version 20.3.
Key Features of Git Integration:
- Streamlined Version Control: ER/Studio 20.3 offers robust Gitの統合, transforming how users manage and version their data models.
- Direct Repository Commit: Users can commit versions of the Create DDL or JSON for an asset directly to their Git repository.
- Schema Upgrades and Management: The update emphasizes the importance of scripts for upgrading existing schemas, with Compare/Merge features allowing users to generate ALTER scripts to move from a previous database version to the latest.
Connecting Data Modeling into your CI/CD Pipelines
This powerful integration embeds data modeling into the CI/CD pipeline, enhancing the efficiency and precision of database management processes.
Furthermore, it’s important to have scripts that upgrade existing schemas to the latest version for databases. Thus, you can use our Compare/Merge features to take a previous database version to the latest by generating appropriate ALTER scripts.
Generate and Commit DDL or JSON to Git Repositories
Commit DDL and JSON Files Directly to Git
Users can now generate “Create DDL” scripts or JSON representations from their 物理データモデル and commit these files directly to a Git repository. ER/Studio integrates seamlessly with CI/CD processes, enhancing efficiency.
Compare and Generate ALTER Scripts
- Model Comparison
ER/Studio offers a powerful feature to compare a Physical Data Model with any “Create DDL” version stored in the Git repository. This semantic comparison is easier to understand than the standard text comparison in Git, helping maintain consistency and track changes over time.
- Generate ALTER Scripts
Based on the comparison, users can generate an ALTER script that updates the database from the previous version to the current version reflected in the model. This script ensures that all changes are accurately captured and can be executed to update the database schema.
- Commit ALTER Scripts to Git
Like the “Create DDL,” these ALTER scripts can be committed to the Git repository. This dual approach of committing the initial creation and subsequent alterations ensures comprehensive version control and traceability.
Supported Git Implementations
ER/Studio 20.3 supports various Git repositories, ensuring flexibility and compatibility with your existing DevOps tools. The supported Git implementations include:
- GitHub: The world’s leading platform for open-source collaboration.
- GitLab: Known for its integrated CI/CD capabilities.
- Atlassian Bitbucket: Ideal for teams using Jira for project management.
- Azure Repos: Part of the Azure DevOps suite, offering seamless integration with Microsoft’s ecosystem.
- Assembla: Provides a secure, cloud-based Git service.
Benefits of the ER/Studio 20.3 Git Integration
Seamless Integration with DevOps
Align with Modern DevOps Practices: This feature supports continuous integration and delivery of database changes alongside application code, ensuring you stay current with industry trends.
Save Time with One-Click Commit
Efficient Version Management: Commit your code with the push of a button as you complete a version, saving time and effort.
Extend the Comparison Features of Git
Semantic Comparison: ER/Studio enhances Git by providing a semantic comparison between versions, making it easier to understand differences.
Improved Traceability and Control
Comprehensive Change History: Committing both “Create DDL” and “ALTER” scripts to the repository offers a full history of changes, enhancing tracking, auditing, and security.
Leverage ER/Studio 20.3 for Advanced Data Management
Enhanced Git Integration
ER/Studio 20.3 represents a significant leap forward in integrating ER/Studio into your CI/CD processes to support an effective DevOps program. The new Git integration enhances collaboration, ensures robust version management, and empowers users, giving them better control over their データモデル.
Whether using GitHub, GitLab, Bitbucket, Azure Repos, or Assembla, ER/Studio’s latest update has the tools to streamline your data workflows.
- Improved Collaboration: Facilitates team coordination and version control.
- Robust Version Management: Ensures accurate tracking and management of changes.
- Comprehensive Tool Support: Compatible with major Git platforms like GitHub, GitLab, and others.
Explore ER/Studio 20.3 Today
Ready to explore the new features of ER/Studio 20.3? デモのリクエスト today to see how Git integration and other enhancements can transform your data management.
