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 jenkinsci-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
