"Parsing errors: Parse error: [Incorrect syntax near '='] at [position: 2496, line: 65, column: 36]" Error appears when trying to synchronize a database with the backup of database (4373916)
"Parsing errors: Parse error: [Incorrect syntax near '='] at [position: 2496, line: 65, column: 36]" Error appears when trying to synchronize a database with the backup of database
説明
Create a script folder from any AdventureWorks database and add [BTP_FCTT_GEN_PRODUIT_REMPLACEMENT_LISTE].sql script in the Functions folder
Run ApexSQL Diff
On the source add any database and on the destination side add the script folder created from the AdventureWorks database
Press Compare
対策
WORKAROUND
Modify the code towards the end of the script by removing "IIF(@Nb_Lignes = 0, 20000, @Nb_Lignes)" and using a variable, constant, or <object_name>
STATUS
Waiting for a fix in the future version of ApexSQL Diff