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

February 26, 2020

Perforce Software released a free tool for organizations considering open source software - OpenLogic Stack Builder.

February 26, 2020

Applause announced a new partnership with Infosys to provide broader end-to-end digital experience testing services to clients.

February 26, 2020

RapidMiner announced the release of its platform enhancement, RapidMiner 9.6. This update prioritizes people – not technology – at the center of the enterprise AI journey, providing new, unique experiences to empower users of varying backgrounds and abilities.

February 25, 2020

JFrog announced the availability of the "JFrog Platform," a hybrid, multi-cloud, universal DevOps platform.

February 25, 2020

Nureva added new agile canvas templates to Span Workspace, including a heat map developed by Jeff Sutherland, the co-creator of Scrum and founder of Scrum Inc. and Scrum@Scale.

February 25, 2020

Agiloft announced the addition of its new Agiloft AI Engine, complete with prebuilt AI Capabilities for contract management and an open AI integration that allows customers to incorporate custom-built AI tools into the no-code platform.

February 24, 2020

Cloudify announced that its latest product update - Cloudify version 5 - features an Environment as a Service component, designed to achieve consistent delivery and management of hybrid-cloud services and network infrastructures across CI/CD pipelines - at scale.

February 24, 2020

Checkmarx announced new enhancements to its Software Security Platform to empower more seamless implementation and automation of application security testing (AST) in modern development and DevOps environments.

February 24, 2020

Rapid7 and Snyk announced a strategic partnership to deliver end-to-end application security to organizations developing cloud native applications.

February 20, 2020

The American Council for Technology and Industry Advisory Council (ACT-IAC), the premier public-private partnership dedicated to advancing government through the application of information technology, officially announced the release of the DevOps Primer.

It was produced through a collaborative, volunteer effort by a working group from government and industry, hosted by the ACT-IAC Emerging Technology Community of Interest (COI).

February 20, 2020

DLT Solutions, a subsidiary of Tech Data, launched the Secure Software Factory (SSF), a framework that provides the U.S. public sector with consistent development and deployment of high-quality, scalable, resilient and secure software throughout an application’s lifecycle.

February 20, 2020

Netography announced the general availability of the company’s Security Operations Platform.

February 19, 2020

Perfecto by Perforce announced its integration with Katalon Studio.

February 19, 2020

Radware announced the Alteon Cloud Control as part of its Alteon Multi-Cloud Solution designed to simplify the deployment of secured application delivery services across public and private cloud environments.

February 19, 2020

BluBracket introduced its product suite, a comprehensive security solution for code in the enterprise.