Connect your database with your version control system
Maintain the referential integrity of your database by controlling version control schemas and reference information, rolling back changes, and version control schemas. Other database problems can be solved, such as deploying data without losing it.
Pre and Post-deployment scripts allow you to make SQL changes before and after your deployments. These scripts can be managed in SQL Source Control and then picked up by Redgate products when they are deployed.
SQL Server Management Studio makes it easy to track and share code changes.
It doesn't mean you have to stop doing what you are doing or hand out change scripts.
Share and store any SQL Server object or static data. Two clicks are all it takes to update and commit an SQL Server object in the Object Explorer.
You can see the latest changes by checking SQL lines with highlighted differences.
You can view the complete revision history for a database or object.
It is possible to see who, when, and why the changes were made.
SQL Source Control ensures that your database's referential integrity is maintained for you when you commit or update.
It will determine the best order to make your changes, and it even handles keys and constraints.
It is the same engine used by SQL Compare, the most trusted tool to sync database changes.
Management Studio allows you to sync remote and local Git repositories.
You can pull down the changes from your remote repository and commit them locally. Then, push them straight to your remote repository so you can share your changes with your team.
It is easy to roll back or resolve conflicts using the Object Explorer.
You also have a safe sandbox. You can experiment with your database. Any changes that you do not want to make can be undone.
With just one click, you can lock an object in SQL Server Management Studio. This will ensure that your changes won't be overwritten.
Your team can view what's locked and who locked it.
Your team and you can either work together on a shared database or use your own copy.
SQL Source Control supports both models for database development.
It doesn't matter what you do; it will help you share code, avoid conflict, and see who is doing what so you can collaborate without stepping on each other.
Filters can be used to exclude certain objects (such as permissions or users) from sharing.
You can either exclude objects by name, type, and the owner or create more complicated conditions.
It is easy to share what you want with your team.
The Object Explorer shows you icons that indicate when you or your colleagues have modified a database.
Never forget to commit to version controls.