Consolidating data changes in SQL Server by team
We also use source control for managing schema changes. When it comes to deployment of new versions, I find it irreplaceable. It saves a lot of time and saves oneself from headaches

Red Gate is a good choice, though we went for ApexSQL Diff  and ApexSQL Version

But none of these can track actual data changes. And data changes are not stored in source control

The tool that we use for monitoring data changes is ApexSQL Log, so we can see what data changed (records added, deleted or modified), who made a change and when. It also shows the schema changes - a table modified, a store procedure dropped, etc. Its main request is a database in Full recovery model, which requires regular backups and hard disk space - but on the other hand, you'll be ready if it comes to a disaster recovery ;)