-
Notifications
You must be signed in to change notification settings - Fork 2
SQLDeploy
As of SQLDeploy package version 2.3, the Nuget package defaults to using DacPacs for SQL Server database deployments. Prior versions didn't specify any deployment by default which required more setup by the user to configure what to deploy and how. We believe this change will make SQLDeploy as easy as possible to get started with. That being said, all older SQL deployment options still exist in the package if you need them.
-
Add a new Class Library project to your solution which will act as your SQL deployment project
-
Add the MSDeployAllTheThings.SqlDeploy Nuget package to your SQL deployment project
-
Open the
[ProjectName].spp.targetsfile and update the DatabaseProject node to the name of the SQLServer database project in your solution. -
Build the project with the
/p:DeployOnBuild=trueflag and the MSDeploy package will be created in thebin/[configuration]/sqlDeploymentfolder.
This seems odd to use a Class Library Project to deploy a SQL database. We would prefer to use the Database Project itself but the problem is Nuget doesn't allow you to add a package to a Database project. Not sure why. So, you need another project, it doesn't matter what kind, that will kickoff MSBuild and support Nuget packages.
- MSDeploy/WebDeploy
- Visual Studio
- SQL Server Data Tools
The version of each will depend on the versions you use on your local development machine.
There have also been reports of the following error with VS2015:
MSDEPLOY : error Code: ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER [D:\Builds\31\EP\Development.Mozaic_Robb\src\Mozaic\Mozaic Sites\DatabaseDeployment\DatabaseDeployment.csproj] More Information: The SQL provider cannot run because of a missing dependency. Please make sure that Microsoft SQL Server Transact-SQL ScriptDom is installed. Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER.
Apparently one of the SQL dlls isn't properly installed in the GAC. You can resolve this by manually installed the dll:
"C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.2 Tools\gacutil" /i "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Microsoft.SqlServer.TransactSql.ScriptDom.dll"