Welcome, New Build Manager!

Hardware Environments

• Web Servers (lms7fixws1/lmsenhws1)
• File Servers (lmsfixfs/lmsenhfs)
• Database Servers (lms7db)
• Build Box (lms7build)
• Subversion Server (subversion)
• Cruise Control Server (vsafe2)

Application/Product Environments

• LMS7
• LAS (LASII)
• LCMS
• LUSAC
• Ecommerce

Build Environments

• lms7build: Automated Build Studio (pullit.bbp), in-house tools (vbs), stage files for each revision
• lms7fixfs: Deploy tools, files for all revisions,builds, and pushes....need cleanup & backup
• subversion: passwd files to control SVN commit (F:\SVN\REPOS\\conf\passwd)
• vsafe2: watchout the over-growing log file (C:\build\server\ccnet.log)
• krieweae7u: Earl's machine for ClearCase files (LCMS)

Build Process

1. Pull source files from source control server (update & compile locally)
2. Build package by revision range or cherry pick
3. Push code to INT by BM or hand them to TIS/DBA to deploy in QA/UAT/PROD
4. Email notification to related parties
5. Advance TTS in ClearQuest
6. Maintenance build environments after monthly builds

Tools

• BuildManager.hta
  • Code: hta
  • Main GUI for Build Manager
  • Server: lms7build
  • Location: C:\_LoadBuild\Tools
• PullIt.bbp
• Code: Automated Build Studio file - need to be restarted every week to rlease memory
• Server: lms7build
• Location: C:\_LoadBuild\Tools\Auto_Build_Studio
• Config file: :\_LoadBuild\Tools\Auto_Build_Studio\PullIt.ini
• BuildIt.vbs
  • Code: VBScript stand alone
  • Server: lms7fixfs
  • Location: F:\ACS\_LoadBuild\Tools
  • Config File: F:\ACS\_LoadBuild\Tools\BuildIt.ini
• PushIt.vbs
• Code: VBScript stand alone
• Server: lms7fixfs
• Location: F:\ACS\_LoadBuild\Tools
• Config File: F:\ACS\_LoadBuild\Tools\PushIt.ini
• SendCompletedEmail.vbs
• Code: VBScript stand alone
• Server: lms7fixfs
• Location: F:\ACS\_LoadBuild\Tools
• Mailing List: F:\ACS\_LoadBuild\Tools\email.dat
• CheckBuildProgress.vbs
• Code: hta (with VBScript) file
• Server: lms7build
• Location: C:\Documents and Settings\hsiehla\My Documents\_BuildManager\Bin
• Backend: ClearQuest server using lang's login criteria
• MaintainUserPassword.wsf - to maintain password
• CheckBuildProgress.bat - interface for BuildManager.hta
• Pull_LAS
  • Server: lms7build
  • Location: C:\Documents and Settings\hsiehla\My Documents\_BuildManager\Bin
  • Code: wsf file
  • New architected build tools
    • wsf + VBScript: includes common function libraries
      • CDOEmail
      • ClearQuest
      • Database
      • Encryption
      • INI
      • OAM
      • RegularExpression
      • Subversion
      • XML
      • FileSystem
    • Structured folders
      • bin
      • conf
      • data
      • lib
      • lock
      • temp
      • work
    • Central INI file: C:\Documents and Settings\hsiehla\My Documents\_BuildManager\Conf\BuildManager.ini
    • Seperated xml file for each subsystem
      • BuildIt.xml
      • FolderStructure.xml
      • SQLDeployment.xml
• Pull_HELP
• Pull_LCMS
• Build_LAS
• Database Object Dependency
  • Server: grahavie7u2003
  • Location: C:\Documents and Settings\hsiehla\My Documents\_LoadBuild\Tools\SSIS\BuildManager\BuildManager.sln
  • Requirement: SQL SQL Server Business Intelligence Development Studio (BIDS-2005 and above)
  • Move to another server: Just Copy/Move over the BuildManager folder under SSIS to another machine with SQL BIDS installed
  • Executions:
    • Double click on BuildManager.sln to open in BIDS
    • Run ReapplyExistingSP_CPE.dtsx under SSIS packages from Solution Explorer (help to rebuild object relationship in SQL due to we restore DB from PROD once a while) - about 15 min
    • Run ReapplyExistingSP_LMS.dtsx under SSIS packages from Solution Explorer (same as CPE) - about 40 min
    • Run FindDependency.dtsx under SSIS packages from Solution Explorer
    • Open DependencyResult_.txt file in Excel to view the result

Communications

• Push: DBA + TIS + Tritschler + Mahagan
• INT: all Dev + Tritschler + Mahagan
• QA: all QA + all SM/PM + Tritschler + Mahagan + McBride + Martha
• PROD: all QA + all SM/PM + Tritschler + Mahagan + McBride + Martha