I am looking for applications around Microsoft's SQL Server. I am trying to gather data on which tools would make a DB team agile by automating a lot of their current manual tasks. Some of those tasks include automatic/promoted deployments, database versioning, source control, and being able to reliably test their scripts without having to muck with the database.<p>Some of the tools I have started to investigate are:<p><pre><code> - Redgate's technologies
- ApexSQL's technologies
- SSDT (SQL Server Data Tools)
- Navicat for SQL Server
</code></pre>
Are there others out there that I might be missing out on? What have you used to solve these kinds of problems?
None of the things you're looking for are going to help your team much unless they already have a good understanding of relational DB theory and some experience.<p>That being said, I do like DataGrip by JetBrains for general SQL usage.<p>Visio is fine for generating diagrams if you've already got licenses, though there are far better products if not.