How can we help you today? How can we help you today?

SSMS 18 Command Line Invalid

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


Dave Pendleton
0

Comments

6 comments

  • 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).
    Sergio R
    0
  • Dave Pendleton
    I'm using SQL Compare, not the command line.


    Dave Pendleton
    0
  • 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"



    Sergio R
    0
  • Dave Pendleton
    It works fine, but I can't control the command line used inside SQL Compare.
    Dave Pendleton
    0
  • 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.
    Sergio R
    0
  • 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
    0

Add comment

Please sign in to leave a comment.