Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Would you consider using an alternative to MS SQL Server Management Studio? [closed]

At work we recently upgraded from Microsoft SQL Server 7 to SQL 2005. The database engine is a lot more advanced, but the management studio is pretty awful in a number of ways. Most of our developers decided they preferred to stick with the old Query Analyzer tool, even though it had a lot of limitations.

In my spare time, I decided to write a replacement for Query Analyzer / Management Studio that did the things our developers most needed to do. I finally got permission to release it for free: Versabanq Squel (versabanq.com/squel).

Like I said, it's free, so this isn't a sales pitch. But it got me thinking. What I'm wondering is: are most of you satisfied with SQL Studio the way it is? Do people just use it because it's what Microsoft pushes on them? Are there many people out there looking for something better? Maybe I can get some support for long-term development of this, if it looks like there might be some wider interest.

By the way, check out SQL Server Management Studio Alternatives, someone else's earlier question on this topic. What I see there is that there are surprisingly few options. Why do you think that is?

like image 639
apenwarr Avatar asked Dec 12 '08 23:12

apenwarr


People also ask

Is Microsoft SQL Server Management Studio necessary?

To use a SQL Server database on a PC, you must install the SQL Server database engine on that PC (or have it available somewhere in the network which can be reached from that PC). But installing SQL Server Management Studio is definitely NOT a requirement.

What can I use instead of SSMS?

Microsoft SQL Server, MySQL WorkBench, Microsoft Access, AzureDataStudio, and PostgreSQL are the most popular alternatives and competitors to Microsoft SQL Server Management Studio.

Can I install Management Studio without SQL Server?

It is possible to install SQL Server Management Studio on local machine without having other SQL Server components. Below we will demonstrate different ways to install SSMS step by step on a local machine and how to connect to the remote instance using SSMS.

Can I use Azure data studio instead of SSMS?

Despite being a truly an awesome tool, Azure Data Studio still lacks some key features in order to be considered as a direct substitute for SSMS. That's especially true for DBAs tasks, where SSMS as a mature tool offers many more options.


1 Answers

Ha, I came from exactly the same standpoint, so I made a tool, code completion and all, plus there's a free edition available. It's at http://www.atlantis-interactive.co.uk - it's basically for people who miss QA. Your tool looks nice, good job.

like image 100
Matt Whitfield Avatar answered Oct 12 '22 01:10

Matt Whitfield