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.
2
-2
Was this article helpful?
0 out of 2 found this helpful
Articles in this section
- The process cannot access the file 'C:\Users\*******\AppData\Local\Red Gate\SQL Source Control 7\Caches
- Duplicate definition troubleshooting in SQL Source Control
- The target principal name is incorrect
- SQL Source Control can't access this database - make sure the database is online and you have permission to access it
- Meanings of the colored dots in the SSMS Object Explorer for SQL Source Control
- Last Changed By column shows Unknown
- How to Link SQL Source Control to TFS
- How to link to an existing SVN repository
- GIT Push/Pull greyed out
- Objects changed by unknown