Redgate Releases SQL Change Automation 4.0
September 17, 2019

Redgate launched SQL Change Automation 4.0, extending its database change management automation tool to the free Microsoft SQL Server Management Studio (SSMS) development environment for the first time.

SQL Change Management empowers developers to automate the DevOps database delivery process by building, testing, and deploying database changes checked into version control, for SQL Server, Azure SQL Database, and Azure SQL Database Managed Instances.

With the new SSMS extension, developers can now choose whether to work in Microsoft Visual Studio or SSMS, with team members able to use both development environments to share and collaborate seamlessly on the same projects. Alternatively, users can standardize on a single development environment, depending on their particular needs.

This new capability especially benefits heterogenous development teams where developers and database administrators want to use their development environment of choice, but still follow the same DevOps processes when it comes to database changes. For example, specialist database developers and DBAs prefer to work with SSMS even if they are collaborating with full stack developers who use Visual Studio. They now don’t need to learn to use new development environments, maximizing their effectiveness and making adoption easier while enabling efficient team working.

Thanks to the rise of Database DevOps, companies are increasingly adopting Continuous Integration and Continuous Delivery of database changes. SQL Change Automation supports this, freeing teams from manual database change management tasks, like sorting out deployment scripts, speeding up deployments and enabling developers to focus on more value-added work instead.

As Robert Farrell, Product Manager, Redgate Software, comments: “Redgate is dedicated to delivering choice to users - letting teams work in the environments and tools that they are most familiar with, reducing learning curves and enabling greater collaboration. The latest version of SQL Change Automation supports this philosophy, extending its capabilities and ensuring that database code quality and automation is at the heart of DevOps processes, bringing stability and speed.”

Other features of SQL Change Automation v4 include static code analysis and new data compare options for PowerShell. Static code analysis identifies potential problems with migration scripts to be deployed and warns the user about them, before changes are made to Production, ensuring best practices are being followed.

SQL Change Automation allows finer control of options to support the automation of changes to static data within PowerShell. It also continues to integrate with popular version control systems and orchestration tools, and SQL Change Automation PowerShell cmdlets and graphical extensions enable users to implement Continuous Integration and Continuous Delivery for database changes.

Share this

Industry News

October 10, 2019

CloudBees launched a new partner program that expands ISV partners’ ability to align with CloudBees offerings and the global Jenkins community.

October 08, 2019

Nureva announced a key update to the Jira Software integration with Span Workspace, Nureva’s cloud-based digital canvas for visual planning and collaboration.

October 08, 2019

Fugue announced support for Open Policy Agent (OPA), an open source general-purpose policy engine and language for cloud infrastructure.

October 03, 2019

Redgate announced the launch of SQL Compare v14, the latest version of its industry standard tool for quickly and accurately comparing and deploying SQL Server databases.

October 03, 2019

Harness announced the release of Continuous Insights, a new capability of its CD platform that enables organizations to see clearly into software delivery performance across their engineering and development teams without needing to manually collect, correlate, and report metrics that might take days or weeks.

October 03, 2019

OutSystems and Workato announced a partnership aimed at allowing organizations to rapidly realize innovation, time to value, productivity, and mission-critical objectives through readily available application connectors.

October 02, 2019

Kong announced an acquisition and several new products.

October 02, 2019

Contrast Security announced the availability of .NET Core support on Contrast Community Edition (CE).

October 02, 2019

Checkmarx earned Amazon Web Services (AWS) Security Competency status for its Software Security Platform.

October 01, 2019

Parasoft announced the release of its newest product, Parasoft Selenic, a UI testing solution that makes Selenium smarter, to help organizations find real bugs faster.

October 01, 2019

Micro Focus announced the general availability of Deployment Automation 6.3, offering new deployment improvements for its Release Orchestration solution set.

October 01, 2019

Compuware announced enhancements to Topaz for Total Test and a partnership with OpenLegacy to help large enterprises speed mainframe software development and delivery while improving quality.

September 30, 2019

Deque Systems announced Axe Pro, a key addition to Axe, the web accessibility testing browser extension.

September 30, 2019

NIIT Technologies and mabl, Inc announced a partnership to deliver AI-driven automated solution for faster, economical and better application testing services.

September 30, 2019

Rockset announced the capability to analyze raw events from Apache Kafka in real time.