Home → Questions →

Database project publishing

• Edit

sergey

14 Oct, 2014 11:58 AM

Hello!

As part of my project I have SQL Server database project (http://msdn.microsoft.com/en-us/data/tools.aspx). 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

   

   Hi Sergey,

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

   • Edit

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

   

   Hi Feodor!

   Thanks for you answer.

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

   • Edit

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

   

   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?

   • Edit

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

   

   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.

   -Feodor

   • Edit

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

   

   Well, I can build SSDT project created with VS Express — https://ci.appveyor.com/project/SergeyZwezdin/test-777/build/1.0.1

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

   • Edit

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

   

   Another option could be updating how web deploy works —
   http://msdn.microsoft.com/en-us/library/hh550081(v=vs.103).aspx

   • Edit

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

   

   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: http://www.iis.net/learn/publish/using-web-deploy/dbdacfx-provider-...

   Is this what you are looking for?

   • Edit

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

   

   Seems it won't help :-(

   I'm still in investigating.

   • Edit

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