This tool offers four key functions:
-
SQL IDE: A basic yet powerful integrated development environment for both Microsoft SQL Server (MSSQL) and MySQL. The tool allows you to run queries, view result sets, and export them as SQL inserts or updates for easy reuse.
-
Table Comparison: Compare two tables in one direction, generating SQL scripts to reflect changes across all fields in the selected table. The tables must have identical structures. During the comparison, the tool creates
INSERTandUPDATEqueries, which can be saved for future execution. Additionally, you can join other tables in the query to limit comparisons to specific records, provided that only fields from the current table are in the final result set. -
Import Utilities: A suite of helper tools to assist with importing data efficiently.
-
Find & Replace: Search for or find-and-replace text across tables and columns, streamlining updates and modifications to your data.
Software Requirements: Windows All or Debian linux
Click the link below to download v1.1.0.2
Click here to Download for Windows All Versions
Click here to download the debian package
Disclaimer: We accept no liability for any loss or damage caused by the downloading, installation and use of this software.
NComp MSSQL Toolbox Change Log or Version History
Features added in version 1.1.0.2 Uploaded 12 November 2024
- Small improvements
Features added in version 1.1.0.1 Uploaded 26 September 2024
- Small fixes
- Ubuntu 24.04 desktop icon fixed
Features added in version 1.1.0.0 Uploaded 10 Januarie 2024
- Mysql functionality added (This function is still in Beta)
- Small fixes
Features added in version 1.0.0.15 Uploaded 29 March 2023
- Small fix to use from fields when to fields is empty with compare
Features added in version 1.0.0.14 Uploaded 30 November 2022
- Compare function is fixed when compare SQL has column names written out instead of a * in select.
Features added in version 1.0.0.13 Uploaded 11 May 2022
- Import function process improved
Features added in version 1.0.0.12 Uploaded 25 Mar 2022
- Visual changes
- Add to SQL area for compare. for when the from and To table name differ.
- INI name has changed, so on first opening updated version all you remembered details will be empty. It will have to be entered again.
Features added in version 1.0.0.11 Uploaded 24 Feb 2022
- Visual changes
- Extra memo field type added for compare function
- Compare function will now save to sql data on exit
Features added in version 1.0.0.10 Uploaded 12 Apr 2021
- Fixed scenario when switching from one server to another and db don't exist.
Features added in version 1.0.0.9 Uploaded 9 Jun 2020
- Added 2 tabs for scripting function. Two separate places where queries can be edited.
- Fixed the black background on the tabs under Windows.
- Fixed an bug in the insert query export function.
Features added in version 1.0.0.8 Uploaded 15 Oct 2019
- Compare fixes and improvements.
Features added in version 1.0.0.7 Uploaded 7 Jul 2018
- Small improvements.
- Import function added an update query export from csv.
Features added in version 1.0.0.6 Uploaded 24 May 2018
- Small improvements.
- Debian linux install package added for download.
Features added in version 1.0.0.5 Uploaded 17 May 2018
- Import helper tools added.
- Scripting improvements.
- Choose database instead of typing it.
Features added in version 1.0.0.4 Uploaded 28 Apr 2018
- Tool renamed from MSSQL Compare to NComp MSSQL Toolbox.
- Export functionality added.
Features added in version 1.0.0.3 Uploaded 6 May 2017
- Tool converted to Lazarus ide environment
- Code clean up.
Features added in version 1.0.0.2 Uploaded 8 May 2014
- Bug fixes
Features added in version 1.0.0.1 Uploaded 8 Feb 2014
- Bug fixes
Features added in version 1.0.0.0
- Initial Release
- Compare two tables