Top 10 SQL Compare Tips. Watch now.

SQL Compare | Errors occurred whilst parsing file

devesharmadevesharma Posts: 4 New member
edited October 13, 2020 9:46AM in SQL Compare
Hi Team,

We are facing a weird issue on our systems where SQL Compare would fail on parsing certain SQL Procedures. Although the same proc we can create manually in the database. It would bomb out with message "SQLCompare.exe terminated with the exit
code 126: Failed due to a SQL Server error.

PS : We are using DLM Automation 2 to promote artifacts to other ENVs

failed: Errors occurred whilst parsing file 
DriveLabel:\Directory\dbo.proc_name.sql
'' at line 5, column 7

SQL Compare : 13.3.6.6387

Any leads would be greatly appreciated.

Regards
Devesh Sharma

Answers

  • Hi @devesharma

    Sorry to hear you're experiencing this issue!

    I think this might be an old bug, I would recommend upgrading to the use of SQL Change Automation which uses version 14.4.7.16917 of the SQL Compare Engine.

    Let me know how that goes!

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.