Ask HN: What SQL tools have you used for agile development?

Y	Hacker News new \| ask \| show \| jobs

2 points by rizowski 3527 days ago

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

Are there others out there that I might be missing out on? What have you used to solve these kinds of problems?

1 comments

hiram112 3526 days ago

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.

link