Top 4 Best SQL Editors

14 February,2016 by Jack Vamvas

Based on a recent poll I took the best\most used  SQL Editor goes to :

SQL Server Management Studio – Query Explorer

Sql_editors

This is not a surprise as it ships with SQL Server and is the default client . Quite often developers will remain with the tools they first started on.   It’s good to maintain an open-mind, there may be more productive methods available.

One factor which will influence sql editor tool choice  is the range of platforms. For example, if a developer or DBA is writing sql code to support multiplatforms such as SQL Server and DB2 , they may look to sql editor tool with standardised support for both platforms.

Lets look at some details

  1. SQL Server Management Studio

Home Page: https://msdn.microsoft.com/en-us/library/mt238290.aspx

Author: Microsoft

Latest Stable Version: SSMS 2016

Written in: C , C++, .Net, t-sql to communicate to DB

Operating System: Windows

 

2.    MS SQL Code Factory

Home Page: http://www.sqlmaestro.com/products/mssql/codefactory/

Author:Maestro Group

Latest Stable Version: 15.7

Operating System: Windows

 

3.DatabaseSpy SQL Editor

Home: http://www.altova.com/databasespy/sql-editor.html

Author: Altova

Latest Stable Version:  2016

Operating System: Windows

 

4. SQuirrel SQL Client

Home Page : http://squirrel-sql.sourceforge.net/index.php?page=screenshots

Author: Colin Bell, Gerd Wagner, Rob Manning and others

Latest Stable Version:  3.7

Written in:  Java

Operating System: Cross Platform

 

Read More on sql tools

SQL server 2008 R2 – Silent installation for the SSMS and client tools

SQL Server - Open SSMS on the Command Line - SQL Server DBA

SQL Server – Open SSMS without the splash screen graphic - SQL ...

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Top 4 Best SQL Editors


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer