Ask HN: What SQL tools have you used for agile development?
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.
Some of the tools I have started to investigate are:
- Redgate's technologies
- ApexSQL's technologies
- SSDT (SQL Server Data Tools)
- Navicat for SQL Server
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.
That being said, I do like DataGrip by JetBrains for general SQL usage.
Visio is fine for generating diagrams if you've already got licenses, though there are far better products if not.