I have 4 sql scripts that I want to run in a DACPAC in PostDeployment, but when I try to build the VS project for 3 of them I get this error:
Only one statement is allowed per batch. A batch separator, such as 'GO', might be required between statements.
The scripts contain only INSERT
statements in different tables on the DB. And all of them are structured like so
IF NOT EXISTS (SELECT 1 FROM dbo.Criteria WHERE Name = 'Mileage') INSERT INTO dbo.Criteria(Name) VALUES ('Mileage'); only on different tables and with different data.
My question is why is VS complaining about 3 of them when all the scripts are the same in terms of syntax and operations?
PS: Adding 'GO' between statements as the error suggests doesn't do anything.
4条答案
按热度按时间eimct9ow1#
I have found the problem. When I added the file in VS I forgot to set
Build Action = None
from the file properties. So changing that fixed the problem and the project now compiles.gev0vcfq2#
Regardless this seems to be pretty old I stuck for some hours with that as well and I think this way could be helpful for many.
In
Database project
, files set asBuild
are considered as Database structure so just one statement is allowed in such file by design.Go
nor any other batch terminator will change that behavior, that message is just mistake. More info here.There is lot of other build options for files in such project. For your case it seems that
PostDeploy
. In such file you could have various commands likeinserts
etc.Then you can use output of Database project as dacpac file for Data-Tier DB applications (Otherwise it's not included).
lx0bsm1f3#
I ran into this error when using SQL Server Data Tools and it was because I had a post-deployment script that was added to the project wrong.
In the project file, any database objects should have elements like
But scripts should have
However I added my script file, it ended up with a
Build
tag instead of aNone
. Changing it toNone
fixed the error.suzh9iv84#
Remove the ;(semi-colon) from last of each statement and I am not sure but GO is not required between above insert statements.