Slowness with Deployment of Large Static Data Sets

rexyvanderpool

We have a large database of lookup data that gets changed on a weekly basis and we are using SQL Source Control to control and deploy these changes from our Test to our Production environment. The issue is the job (using Jenkins for deployment by the way) takes 60+ minutes. Is there anything I can do (other than version less data) to speed this up? Does the compare engine utilize indexes on the server side? What about running the compare/checkout on the SQL server side vs our deployment server?

Sergio R

Hi,

Large Static Data sets can be problematic with SQL Source Control, as it's mainly meant to source control the schema and small sets of constant data.

One thing you can try is using our DLM Automation tool which has a Jenkins plugin:
https://wiki.jenkins-ci.org/display/JEN ... +CI+Plugin

Thank you,

rexyvanderpool

Thanks! We'll give this a try