The following DB Migration Tool logs may appear when updating the Deep Security Manager (DSM) Database (DB) Schema:
2016-Oct-24:09:27:34 [+01] INFORMATION Assembly Version [1.0.0.0], File Version [1.0.0.4], Compile Time [2016-Aug-24-14:28:16] 2016-Oct-24:10:17:50 [+01] INFORMATION SQLCMD search directory [C:\Program Files\Microsoft SQL Server\] 2016-Oct-24:10:17:50 [+01] INFORMATION getSQLCmdPath -> No files at [C:\Program Files\Microsoft SQL Server\] 2016-Oct-24:10:18:03 [+01] INFORMATION installDependencies -> SQLCMD search directory [C:\Program Files\Microsoft SQL Server\] 2016-Oct-24:10:18:03 [+01] INFORMATION installDependencies -> No files at [C:\Program Files\Microsoft SQL Server\]
The issue happens because the SQLCMD.exe is installed in a path other than C:\Program Files\Microsoft SQL Server\.
To successfully use the DB Migration Tool, recreate the same installation path under C:\ drive:
- Duplicate the folder containing the SQLCMD.exe file to the folder where migration tool is searching (C:\ drive).
For example, if the SQLCMD.exe file is under D:\Program Files\Microsoft SQL Server\100\Tools\Binn, create C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.exe. - Copy everything under D:\Program Files\Microsoft SQL Server\100\Tools\Binn\ to C:\Program Files\Microsoft SQL Server\100\Tools\Binn.
- Relaunch the DB Migration Tool and then update the Deep Security Manager DB Schema.