SSMS 18 Command Line Invalid

Dave Pendleton

I am unable to script directly to SQL Server Management Studio 18; instead I am presented with the command line syntax dialog for SSMS and then nothing.

SQL Compare Version is 14.0.0.12866
SSMS Version is 18.3.1

Sergio R

This issue was caused by a bug in SQL Compare, which occurred if you used a SQL user only. This issue has been fixed in version 14.1.2

Sergio R

Can you explain in a bit more detail what you are trying to do?

The command-line tool (sqlcompare.exe) is meant to be used on the command line (cmd.exe).

Dave Pendleton

I'm using SQL Compare, not the command line.

Sergio R

I have tested this with that version of SSMS and it's working correctly.
Assuming that you have installed SSMS in the default location what happens if you run the following command on the command line:

"C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.exe" "path to a .sql file"

Dave Pendleton

It works fine, but I can't control the command line used inside SQL Compare.

Sergio R

Yes, I understand that, but that should be the command that SQL Compare is using. I have tried to re-create this on a test environment and in my case it opens the SSMS and a query with the script.