What are the challenges you face when working across database platforms? Take the survey
Options

SSMS 18 Command Line Invalid

Dave PendletonDave Pendleton Posts: 104 Bronze 3
edited October 28, 2019 9:10PM in SQL Compare
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


Tagged:

Best Answer

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools

Answers

  • Options
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • Options
    I'm using SQL Compare, not the command line.


  • Options
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • Options
    It works fine, but I can't control the command line used inside SQL Compare.
  • Options
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.