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

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

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?
chetcreacy
0

Add comment

Please sign in to leave a comment.