{"action":"created","issue":{"url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1594","labels_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1594/labels{/name}","comments_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1594/comments","events_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1594/events","html_url":"https://github.com/OctopusDeploy/Issues/issues/1594","id":74056152,"number":1594,"title":"Octopack - should be able to be added to Database Projects","user":{"login":"dazinator","id":3176632,"avatar_url":"https://avatars.githubusercontent.com/u/3176632?v=3","gravatar_id":"","url":"https://api.github.com/users/dazinator","html_url":"https://github.com/dazinator","followers_url":"https://api.github.com/users/dazinator/followers","following_url":"https://api.github.com/users/dazinator/following{/other_user}","gists_url":"https://api.github.com/users/dazinator/gists{/gist_id}","starred_url":"https://api.github.com/users/dazinator/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dazinator/subscriptions","organizations_url":"https://api.github.com/users/dazinator/orgs","repos_url":"https://api.github.com/users/dazinator/repos","events_url":"https://api.github.com/users/dazinator/events{/privacy}","received_events_url":"https://api.github.com/users/dazinator/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-05-07T17:00:34Z","updated_at":"2015-05-08T11:41:06Z","closed_at":"2015-05-07T23:09:55Z","body":"I hate database projects - DbUp is my preference.\r\n\r\nBut unfortunately, I have to work with them - because I haven't yet got around to convincing everyone in my team that DbUp is better :)\r\n\r\nAt the moment, I can manually add the targets to the .sqlproj file like this: \r\n\r\n```\r\n<Import Project=\"..\\..\\..\\packages\\OctoPack.3.0.31\\tools\\OctoPack.targets\" Condition=\"Exists('..\\..\\..\\packages\\OctoPack.3.0.31\\tools\\OctoPack.targets')\" />\r\n<Target Name=\"EnsureOctoPackImported\" BeforeTargets=\"BeforeBuild\" Condition=\"'$(OctoPackImported)' == ''\">\r\n  <Error Condition=\"!Exists('..\\..\\..\\packages\\OctoPack.3.0.31\\tools\\OctoPack.targets') And ('$(RunOctoPack)' != '' And $(RunOctoPack))\" Text=\"You are trying to build with OctoPack, but the NuGet targets file that OctoPack depends on is not available on this computer. This is probably because the OctoPack package has not been committed to source control, or NuGet Package Restore is not enabled. Please enable NuGet Package Restore to download them. For more information, see http://go.microsoft.com/fwlink/?LinkID=317567.\" HelpKeyword=\"BCLBUILD2001\" />\r\n  <Error Condition=\"Exists('..\\..\\..\\packages\\OctoPack.3.0.31\\tools\\OctoPack.targets') And ('$(RunOctoPack)' != '' And $(RunOctoPack))\" Text=\"OctoPack cannot be run because NuGet packages were restored prior to the build running, and the targets file was unavailable when the build started. Please build the project again to include these packages in the build. You may also need to make sure that your build server does not delete packages prior to each build. For more information, see http://go.microsoft.com/fwlink/?LinkID=317568.\" HelpKeyword=\"BCLBUILD2002\" />\r\n</Target>\r\n```\r\n\r\nOctoPack then runs and packages things up nicely.\r\n\r\nThe problem is, when I update OctoPack through NuGet, I have to remember to manually update these targets in the .sqlproj files.\r\n\r\nCan't Octopack just support this project type?\r\n\r\nIf it did, I'd gladly contribute a step template to the library for deploying the subsequent DacPac that these NuGet packages end up containing.."},"comment":{"url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/comments/100205068","html_url":"https://github.com/OctopusDeploy/Issues/issues/1594#issuecomment-100205068","issue_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1594","id":100205068,"user":{"login":"dazinator","id":3176632,"avatar_url":"https://avatars.githubusercontent.com/u/3176632?v=3","gravatar_id":"","url":"https://api.github.com/users/dazinator","html_url":"https://github.com/dazinator","followers_url":"https://api.github.com/users/dazinator/followers","following_url":"https://api.github.com/users/dazinator/following{/other_user}","gists_url":"https://api.github.com/users/dazinator/gists{/gist_id}","starred_url":"https://api.github.com/users/dazinator/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dazinator/subscriptions","organizations_url":"https://api.github.com/users/dazinator/orgs","repos_url":"https://api.github.com/users/dazinator/repos","events_url":"https://api.github.com/users/dazinator/events{/privacy}","received_events_url":"https://api.github.com/users/dazinator/received_events","type":"User","site_admin":false},"created_at":"2015-05-08T11:41:06Z","updated_at":"2015-05-08T11:41:06Z","body":"- looks like nuget won't be addressing this issue anytime soon either: https://github.com/NuGet/Home/issues/545"}}