Time taken for database deployment using Teamcity and Redgate tools

deeps

I use teamcity for CI process of database with the help of Redgate DLM automation build and Redgate DLM automation Sync step. It is taking about minutes to complete the 2 steps. Is there any method to reduce the time taken to complete the process?

Diogo

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.

deeps

It takes about 40 minutes to complete the build.

AlexYates

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)

way0utwest

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

deeps

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