concatSQL

This software offers a variety of features for SQL scripting and database maintenance. One of its primary capabilities is the ability to concatenate and execute SQL scripts that include predefined placeholders. These placeholders can be custom-defined by the user and can save time and effort when executing scripts against multiple databases.

The software also has the capability to reverse engineer databases, generating SQL scripts that can be used for maintenance and updates. Users can create hierarchical concatenation of multiple file manifests, grouping SQL files together for patch maintenance. The software is compatible with both MS SQL Server 2008/2012 and MySQL5.6, allowing for flexibility in database connectivity.

File management is easy with the ability to drag and drop files into file manifests and order or index them as required. Batches of SQL scripts can be managed, saving users time and money. Text files and SQL scripts can be concatenated in seconds, with placeholders implemented and tested against a test database.

New databases can be created from scratch using either the 'master' or 'mysql' base databases. File version numbers can be maintained and the software is compatible with third-party applications such as Beyond Compare for file comparison and EditPad Pro, Visual Studio, and SQL Server Management Studio for file editing.

Overall, this software offers a comprehensive solution for SQL scripting and database maintenance, with a variety of useful features for efficient and effective management.