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

SSC "Get latest" gets parsing error on static table data file

chetcreacychetcreacy Posts: 1 New member
edited October 26, 2021 7:17PM in SQL Source Control
SQL Source Control (Version 7.2.52.14049) within SSMS (SQL Server Management Studio) will not allow me to "Get latest"  when the Options "Check for changes to static data" is checked. It is getting a Scripts Folder Command error. The full error text is:
RedGate.SQLDataCompare.Engine.ComparisonSessionSQLException: Scripts Folder Command --->
RedGate.SQLDataCompare.Engine.FolderReader.DataSqlParseException of "One or more data SQL files could not be
parsed. Expected a method to be in the update statement. Found = at file offset 110. Table
affected: dbo.tblNotification File: C:\.....\dbo.tblNotification_Data.sql.
The dbo.tblNotification_Data.sql file was created by SQL Source Control many months ago and resides in the git repository. I pasted the contents of this file into a new SSMS Query window and it parses perfectly fine.

Any ideas how to resolve this parsing issue?
Sign In or Register to comment.