Database project publishing

sergey's Avatar


14 Oct, 2014 11:58 AM


As part of my project I have SQL Server database project ( So, as part of my build process I want to publish this to SQL Server.

Could you help me how I can do that with AppVeyor?

  1. Support Staff 1 Posted by Feodor Fitsner on 14 Oct, 2014 06:16 PM

    Feodor Fitsner's Avatar

    Hi Sergey,

    Database projects is a part of full Visual Studio which is not available on AppVeyor build workers.

  2. 2 Posted by sergey on 15 Oct, 2014 05:03 AM

    sergey's Avatar

    Hi Feodor!

    Thanks for you answer.

    Any chance it will be available? It's blocking for us now.

  3. 3 Posted by sergey on 15 Oct, 2014 09:04 AM

    sergey's Avatar

    Just made small investigation.

    1. Here is mentioned, that build controller have "Visual Studio Express 2013 for Web with Update 3" installed.
    2. SSDT page contains info, that it supports Express:

    SQL Server tooling in Visual Studio 2013 - all the great database tools, now acquisition and updates are fully integrated in Express for Web

    So, we have a chance SSDT will work on AppVeyor's build controllers?

  4. Support Staff 4 Posted by Feodor Fitsner on 16 Oct, 2014 12:38 AM

    Feodor Fitsner's Avatar

    If SSDT is what you are looking for then, yes, it should be there on build workers.

    Give it a try and let me know if there are any issues.


  5. 5 Posted by sergey on 17 Oct, 2014 01:12 PM

    sergey's Avatar

    Well, I can build SSDT project created with VS Express —

    Is it possible to add option to "Deployment" section where I can setup database deployment?

  6. 6 Posted by sergey on 17 Oct, 2014 01:31 PM

    sergey's Avatar

    Another option could be updating how web deploy works —

  7. Support Staff 7 Posted by Feodor Fitsner on 18 Oct, 2014 03:47 AM

    Feodor Fitsner's Avatar

    Thanks for the link to your toy project.

    So, the database project produces .dacpac file as an artifact which can be later used to synchronize remote database using Web Deploy. Synchronizing remote SQL Server database directly is not the case because, obviously, SQL Server is not exposed to the world. What you want is to sycn .dacpack through remote Web Deploy service, either WMSvc or MsDepSvc, kind of:

    msdeloy.exe -Verb:Sync -Source:dbDacFx=”Data Source=.\SQLEXPRESS; Database=OldDatabase; User ID=sa; Password=P@$$W0rd”,IncludeData=false,IncludeTransactionScripts=false -Dest:dbDacFx=”Data Source=.\SQLEXPRESS; Database=NewDatabase; User ID=sa; Password=P@$$W0rd”,computername=https://RemoteMachine:8172/msdeploy.axd?site=”Default Web Site”,username=iisAdmin,password=pa$$word,authtype=basic -allowuntrusted

    I've got that sample from here:

    Is this what you are looking for?

  8. 8 Posted by sergey on 22 Oct, 2014 12:20 PM

    sergey's Avatar

    Seems it won't help :-(

    I'm still in investigating.

  9. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 01:49 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac