For publish
For generating script instead of publish
"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" /Action:Publish /SourceFile:"C:\Source\Database\bin\Debug\database.dacpac" /TargetConnectionString:"Data Source=DataServers;Integrated Security=False;Initial Catalog=DatabaseName;User ID=UserName;Password=pwd;" /v:= /v: = /p:DropObjectsNotInSource=False /p:BlockOnPossibleDataLoss=True
For generating script instead of publish
"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" /Action:Publish /SourceFile:"C:\Source\Database\bin\Debug\database.dacpac" /TargetConnectionString:"Data Source=DataServers;Integrated Security=False;Initial Catalog=DatabaseName;User ID=UserName;Password=pwd;" /v:= /v: = /p:DropObjectsNotInSource=False /p:BlockOnPossibleDataLoss=True /OutputPath:"C:\Deploy.sql"
Nice! This is definitely useful in automation...
ReplyDeleteI guess the second example is /Action:Script instead of /Action:Publish.
ReplyDeletesalt likit
ReplyDeletesalt likit
dr mood likit
big boss likit
dl likit
dark likit
JEMFH