Slowness with Deployment of Large Static Data Sets

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?
Rex Vanderpool
Arrowhead General Insurance

Comments

Sign In or Register to comment.