All Questions
2 questions
1
vote
0
answers
207
views
Visual Studio Database Project; SQLCMD reference all files in a folder
I have a database project with a pre-deployment script in which I reference several sql script and xml files. For example:
:r .\PostDeployment\StaticData.sql
DECLARE @xmlMyFile1 XML =
$(APOS)
:r ..\...
- 5,869
3
votes
1
answer
9k
views
Visual Studio: use SQLCMD variables to change DB types at deploy time
We have a DB project in Visual Studio and it produces a .dacpac file. We then use this dacpac with sqlcommand.exe to deploy our database.
Our requirement is to be able to change column types at ...
- 3,067