Just be clear, Redgate isn't a source control management system. It's a way of integrating with TFS or Git or Mercurial or Subversion. Pick the source control system that your development team is already using would be my first recommendation. Then you can automate getting your databases into source control using Redgate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning