VS2012, use Jenkins with Git and Msbuild
the database project i do not use import database as expect to use git to download source to local and use Jenkins to deploy sp_insert_rpt_criteria already exist, then i create sp_insert_rpt_criteria2 and copy code to database project in Jenkins, build success, however, stored procedure do not exist in database after search with SELECT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE '%sp_insert_rpt_criteria2%' AND OBJECTPROPERTY(id, 'IsProcedure') = 1 GROUP BY OBJECT_NAME(id) Started by user anonymous <http://localhost:8080/user/null> Building in workspace C:\Program Files (x86)\Jenkins\jobs\testing004\workspace Checkout:workspace / C:\Program Files (x86)\Jenkins\jobs\testing004\workspace - hudson.remoting.LocalChannel@ee8538 Using strategy: Default Last Built Revision: Revision cba51fdbcdee2a075d79de74143fc032b6cc5958 (origin/HEAD, origin/master) Fetching changes from 1 remote Git repository Fetching upstream changes from origin Seen branch in repository origin/HEAD Seen branch in repository origin/master Seen 2 remote branches Commencing build of Revision cba51fdbcdee2a075d79de74143fc032b6cc5958 (origin/HEAD, origin/master) Checking out Revision cba51fdbcdee2a075d79de74143fc032b6cc5958 (origin/HEAD, origin/master) Warning : There are multiple branch changesets here Path To MSBuild.exe: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\MSBuild.exe Executing the command cmd.exe /C C:\Windows\Microsoft.NET\Framework64\v4.0.30319\MSBuild.exe C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3.sln && exit %%ERRORLEVEL%% from C:\Program Files (x86)\Jenkins\jobs\testing004\workspace [workspace] $ cmd.exe /C C:\Windows\Microsoft.NET\Framework64\v4.0.30319\MSBuild.exe C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3.sln && exit %%ERRORLEVEL%% Microsoft (R) Build Engine version 4.0.30319.17929 [Microsoft .NET Framework, version 4.0.30319.18034] Copyright (C) Microsoft Corporation. All rights reserved. Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch. Build started 9/5/2013 3:42:09 PM. Project "C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3.sln" on node 1 (default targets). ValidateSolutionConfiguration: Building solution configuration "Debug|Any CPU". Project "C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3.sln" (1) is building "C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3\Database3.sqlproj" (2) on node 1 (default targets). GenerateSqlTargetFrameworkMoniker: Skipping target "GenerateSqlTargetFrameworkMoniker" because all output files are up-to-date with respect to the input files. CoreCompile: Skipping target "CoreCompile" because all output files are up-to-date with respect to the input files. SqlBuild: Skipping target "SqlBuild" because all output files are up-to-date with respect to the input files. CopyFilesToOutputDirectory: Database3 -> C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3\bin\Debug\Database3.dll SqlPrepareForRun: Database3 -> C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3\bin\Debug\Database3.dacpac IncrementalClean: Deleting file "C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3\obj\Debug\Model.xml". Done Building Project "C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3\Database3.sqlproj" (default targets). Done Building Project "C:\Users\LAB-User2\Documents\GitHub\testing005\Database3\Database3.sln" (default targets). Build succeeded. 0 Warning(s) 0 Error(s) Time Elapsed 00:00:00.36 Finished: SUCCESS -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
