SqlPackageExecutable - System Parameter
The System parameter SqlPackageExecutable is used by the Nodinite Logging Service and contains the local path of the SQL Package executable (SQLPackage.exe), also called DACFRAMEWORK and/or DACPAC, for the currently installed version of Microsoft SQL Server. The SQL binaries must be installed, and the path must point to the same physical path on all Nodinite application servers with either the Install and Update Tool and/or the Logging Service.
When the time has come to create a new Nodinite Log Database, the Nodinite Logging Service uses the sqlpackage.exe to install and register the new database. If there is any problem with the DACFRAMEWORK, the new database will not be created and data will continue to grow in the existing online Log Database.
Download and install the latest sqlpackage
| System Parameter Name | Data Type | Values/Example | Comment |
|---|---|---|---|
| SqlPackageExecutable | string | Path to SQLPackage.exe | You must use a version that matches the highest used version of SQL Server |
This feature was introduced with version 4.0
Example Paths for SqlPackage
The following SQL Versions are supported by Nodinite
64 Bit
| Version of Folder | SQL Version | Possible path | |
|---|---|---|---|
| 160 | SQL Server 2019 | "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" | This is where 161 versions gets installed by default |
| 150 | SQL Server 2019 | "C:\Program Files\Microsoft SQL Server\150\DAC\bin\SqlPackage.exe" | |
| 140 | SQL Server 2017 | "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" | |
| 130 | SQL Server 2016 | "C:\Program Files\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe" | |
| 120 | SQL Server 2014 | "C:\Program Files\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" | |
| 110 | SQL Server 2012 | "C:\Program Files\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" | |
| 105 | SQL Server 2008 R2 | "C:\Program Files\Microsoft SQL Server\105\DAC\bin\SqlPackage.exe" |
32 Bit
| Version of Folder | SQL Version | Possible path |
|---|---|---|
| 160 | SQL Server 2019 | "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" |
| 150 | SQL Server 2019 | "C:\Program Files (x86)\Microsoft SQL Server\150\DAC\bin\SqlPackage.exe" |
| 140 | SQL Server 2017 | "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" |
| 130 | SQL Server 2016 | "C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe" |
| 120 | SQL Server 2014 | "C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" |
| 110 | SQL Server 2012 | "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" |
| 105 | SQL Server 2008 R2 | "C:\Program Files (x86)\Microsoft SQL Server\105\DAC\bin\SqlPackage.exe" |
Warning
However, just because you have a folder with one of these identifiers, does not mean you have a SQL Server instance of that version installed; some folders are laid down by newer versions for backward compatibility reasons, added by Visual Studio and other tools, or are left behind after an instance has been removed or upgraded.
One way to get the installed version of SQL Server:
Here's an example of a version of SQL Server.
Info
Remember to Uninstall the older versions, if you install a newer version.
Frequently asked questions
Additional solutions to common problems and the Nodinite System Parameters FAQ exist in the Troubleshooting user guide.
How do I change the value?
Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.
You must have a user with the same password in the master or target server
If you encounter a problem deploying the databases using the SQLPackage.exe, for example, the exception listed below; Update SSMS to 17.3 or later.
You must have a user with the same password in master or target server
Download and install the latest sqlpackage