Out of Memory Exception when trying to commit linked data

If you link a large amount of data in SQL Source Control, you are likely to get an Out of Memory Exception when trying to commit linked data. This is because linking to data affects the performance of SQL Source Control.

We recommend you only source-control static data (also known as lookup or reference data). If static data is slowing down performance, on the Setup tab, under Options just for this database, disable checks for changes to static data.

You should use SQL Data Compare to sync non static data between your environments.

 

Was this article helpful?

0 out of 2 found this helpful
Have more questions? Submit a request