Publish database project using MsBuild
I have a database project in my solution. It comes with the Local.Datatabase.publish.xml. After building the project, if I double click on the xml file, I'm able to publish the changes to my local database.
I like to automate this process. Using MsBuild, I like to be able to do the same thing.
I've set
$msbuildtoC:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe
Unfortunately, $msbuild /t:Publish /p:SqlPublishProfilePath="Local.Database.publish.xml" isn't working.
How can I publish a database project using MsBuild?
Solution
The database projects create bacpac files after build. I can use the sqlpackage, and funnel the connection string in as the parameter.
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120\SQLPackage.exe" /a:Publish /TargetConnectionString:"Data Source=(local); Initial Catalog=Database; Integrated Security=SSPI;" /SourceFile:"D:\project\bin\Debug\projectname.dacpac"
- How to determine if a property is required?
- .NET 4.5 changing how Response.IsRequestBeingRedirected behaves on Ajax calls - why?
- CancellationToken with async Dapper methods?
- How to check if a number is a power of 2
- How to stop Visual Studio from adding IIS Express to launchsettings
- How do I create a generic converter for units of measurement in C#?
- WinUI 3 Community Toolkit: Undefined namespace XAML
- The constraint reference 'string' could not be resolved to a type. (netcoreapp3.0)
- "File Not Found" while trying to compile an RC file (probably dumb mistake)
- Using Snyk Build Task in Azure DevOps Pipeline Error for .Net 8 Project
- How to conditionally use the 'default' color in MAUI?
- Automatically Install Module/Extension in DNN (DotNetNuke)
- Can you explain difference between StrictMock and Partialmock?
- Stubbing a read only property with Rhino Mocks
- Retrieve the current view name in ASP.NET MVC?
- How to Use UnsafeAccessor to Check if Autofac.Core.Lifetime.LifetimeScope IsDisposed in .NET 8?
- How do I convert hexidecimal to decimal using C# & BigInt?
- How do I truncate a .NET string?
- KERNELBASE.dll Exception 0xe0434352 offset 0x000000000000a49d
- .NET MAUI Hybrid Blazor Copy to Clipboard
- How to bind the IsEnabled property to an OR of two values?
- error MSB3073: The command "npm install" exited with code 1
- CSharp Console - Account Login
- EF Core 9 .HasConversion
- How do strings work when shallow copying something in C#?
- How to set the target framework to v2.0 or v3.5 instead of 4.0 when compiling a program from a source file?
- How is it possible to see C# code after compilation/optimization?
- Start exe even with missing dependency dlls?
- Using Action(Of T...) over a custom delegate syntax for readability
- Is C# compiler not reporting all errors at once at each compile?