Automate processes

Last modified: October 28, 2024

The dbForge SQL Complete tool offers a range of advanced features, such as powerful IntelliSense-style SQL completion, code refactoring, code formatting, and other smart productivity functionality, designed to help developers develop code in SQL Server Management Studio and Visual Studio.

In the automated CI process, SQL Complete serves as an auxiliary tool that allows you to format the database creation scripts or the database update scripts before they are included in a NuGet package.

See how the solution allows you to automate different processes when Continuous Integration (CI) is configured.

Format scripts

You can automate code formatting using the command line in different ways:

• Format code from the command line
• Use cmdlets included in dbForge DevOps Automation

Find invalid objects

You can automate the process of finding invalid objects in different ways:

• Find invalid objects in a SQL Server database
• Use cmdlets included in dbForge DevOps Automation

Note

For both formatting scripts and finding invalid objects, you can use the dbForge DevOps Automation plugins for:

• TeamCity
• Jenkins
• Bamboo
• Azure DevOps