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.
You can automate code formatting using the command line in different ways:
You can automate the process of finding invalid objects in different ways:
Note
For both formatting scripts and finding invalid objects, you can use the dbForge DevOps Automation plugins for: