I am deploying dacpac to azure sql db using SqlAzureDacpacDeployment@1 and it is giving me an error in a predeployment script.
This is my predeployment sql in database project
PRINT 'Something';
GO
PRINT 'Execute delete script';
GO
DELETE FROM SchemaName.TableName
WHERE ID IS NULL or AnotherIDColumn is NULL;
GO
Print 'Something';
GO
The error I am getting from azure devops pipeline execution: Error SQL 72014: . Net SqlClient Data Provider: Msg 208, Level 16, State 1, Line 1 nvalid object name 'Schemaame.TableName. Error SQL72045: Script executiom error
I tried to update this line DELETE FROM SchemaName.TableName from script sql to below:
DELETE FROM [SchemaName].[TableName]
Can anyone please help? Note: This is being run for the first time.
