This tool have 4 functions:
1. Basic MSSQL IDE. The result set can also be exported as inserts or updates.
2. Compare 2 tables one way, during the run it will create sql scripts of all the changes to all the fields in the selected table. Both tables should have the same structure during the run. Insert and Update query's are created during the run and can be saved for later execution.
Joins can be added to the from query if only certain records should be compared, as long as the end result only have the current table fields visible.
3. Import help utilities.
4. Find or find and replace text over tables and columns.
Software Requirements: Windows All or Debian linux
Click the link below to download v1.1.0.0.
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.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