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

July 09, 2020

ShiftLeft released a new version of NextGen Static Analysis (NG SAST), including new workflows, purpose-built for developers that significantly improve security, while enhancing productivity.

July 09, 2020

RunSafe Security announced a partnership with JFrog that will enable RunSafe to supercharge binary protections via a simple plugin that JFrog users can deploy within their Artifactory repositories and instantly protect binaries and containers.

July 09, 2020

LeanIX closed $80 million in Series D funding led by new investor Goldman Sachs Growth.

July 08, 2020

Afi.ai introduced Afi Data Platform, a cloud-based replication and resiliency service that helps to monitor, predict downtime and recover K8s applications.

July 08, 2020

D2iQ announced the release of Conductor, a new interactive learning platform that enables enterprises to access hands-on cloud native courses and training.

July 08, 2020

SUSE entered into a definitive agreement to acquire Rancher Labs.

July 07, 2020

Micro Focus announced AI-powered enhancements to the intelligent testing capabilities of the UFT Family, a unified set of solutions designed to reduce the overall complexity of automating the functional testing processes.

July 07, 2020

Push Technology announced the launch of a new Service API capability for Diffusion Cloud, Push’s Real-Time API Management Cloud Platform.

July 07, 2020

Lightrun exited stealth and announced $4M in seed funding for the first complete continuous debugging and observability platform for production applications.

July 01, 2020

JFrog announced the launch of ChartCenter, a free, security-focused central repository of Helm charts for the community.

July 01, 2020

Kong announced a significant upgrade to open source Kuma, Kuma 0.6, available today.

July 01, 2020

Compuware Corporation, a BMC company, announced new capabilities that further automate and integrate test data and test case execution, empowering IT teams to achieve high-performance application development quality, velocity and efficiency.

June 30, 2020

Couchbase announced the general availability of Couchbase Cloud, a fully-managed Database-as-a-Service (DBaaS).

June 30, 2020

Split Software announced new capabilities designed to accelerate the adoption of feature flags in large-scale organizations.

June 30, 2020

WhiteHat Security announced a discounted Web + Mobile Application Security bundle to help organizations secure the digital future.