Time taken for database deployment using Teamcity and Redgate tools

• 
  I don't think there's much you can do to speed it. May be it's just taking a bit of time to compare your the build artifact against your production database if you're dealing with a large database.

  Diogo August 17, 2018 09:59

  - 0 +
• 
  It takes about 40 minutes to complete the build.

  deeps August 17, 2018 10:24

  - 0 +
• 
  It's worth taking a look at the specs of your build agent.
  
  Often TeamCity build agents run on cheap hardware because compiling .NET code isn't particularly resource intensive. Running a DB build is quite different.
  
  Does it take a similar amount of time to run a build on your local machine? You can test this out by running the build manually using PowerShell. (See example 3 at the bottom of these docs: https://documentation.red-gate.com/sca3/reference/powershell-cmdlets/sync-databaseschema)

  AlexYates August 17, 2018 10:40

  - 0 +
• 
  I'd be curious to see the logs with timing.  Where is this slow?
  

  way0utwest August 17, 2018 14:58

  - 0 +
• 
  Most of the time is taken in the build step, where a temporary database is build from scratch.It takes around 20-25 minutes.

  deeps August 21, 2018 09:39

  - 0 +

Add comment

Please sign in to leave a comment.