concatSQL!

concatSQL! version 4.0, developed by Cove Bay Software Limited, is a powerful and versatile tool in the "Development Tools" category, specifically under "Database Tools". With concatSQL.exe, users can concatenate and execute SQL scripts containing placeholders efficiently. The program offers several useful features, including the ability to reverse engineer databases into SQL scripts promptly, saving both time and money.

Designed for both MS SQL Server 2008 / 2012 and MySQL5.6, this tool simplifies the drag and drop of files into hierarchical file manifests, making SQL patch maintenance a breeze. Users can manage, order, and index files as needed. One of the highlights is its ability to concatenate text files and SQL scripts in seconds, enabling swift execution or testing of these scripts against a test database.

This free version supports creating databases from scratch using base databases like 'master' or 'mysql'. Additionally, users can reverse engineer existing MS SQL Server or MySQL databases into SQL scripts swiftly. Managing batch SQL scripts has never been easier. Furthermore, concatSQL! is compatible with third-party applications for file comparison (such as Beyond Compare) and file editing tools like EditPad Pro, Visual Studio, and SQL Server Management Studio.

Other versions including 3.0 are also available, ensuring a range of functionalities for different user needs.

Pros:

• Efficiently concatenates and executes SQL scripts
• Supports MS SQL Server and MySQL databases
• Facilitates reverse engineering of databases
• Free to download and use with essential features
• Third-party application compatibility

Cons:

• Limited to specific SQL server versions
• Interface may be complex for beginners

You may want to check out more software, such as EMS SQL Manager 2005 for PostgreSQL, SQL Query for SQL Server or DeskWinNC, which might be similar to concatSQL!.