I was wondering if there are any alternatives to Microsoft's SQL Server Management Studio?
我想知道微软的SQL Server Management Studio是否还有其他的选择?
Not there's anything wrong with SSMS, but sometimes it just seem too big an application where all I want todo is browse/edit tables and run queries.
SSMS并没有什么问题，但有时它看起来太大了，我只想浏览/编辑表并运行查询。
12 个解决方案
#1
45
I've started using LinqPad. In addition to being more lightweight than SSMS, you can also practice writing LINQ queries- way more fun than boring old TSQL!
我开始使用LinqPad。除了比SSMS更轻量级之外，您还可以练习编写LINQ查询——比枯燥的旧TSQL更有趣!
#2
18
Seems that no one mentioned Query Express (http://www.albahari.com/queryexpress.aspx) and a fork Query ExPlus (also link at the bottom of http://www.albahari.com/queryexpress.aspx)
似乎没有人提到查询Express (http://www.albahari.com/queryexpress.aspx)和一个fork查询ExPlus(也链接在http://www.albahari.com/queryexpress.aspx的底部)。
BTW. First URL is the home page of Joseph Albahari who is the author of LINQPad (check out this killer tool)
顺便说一句。第一个URL是Joseph Albahari的主页他是LINQPad的作者(看看这个杀手工具)
#3
18
TOAD for MS SQL looks pretty good. I've never used it personally but I have used Quest's other products and they're solid.
SQL女士的癞蛤蟆看起来不错。我从未用过它，但我用过Quest的其他产品，它们很结实。
#5
13
I have been using Atlantis SQL Enywhere, a free software, for almost 6 months and has been working really well. Works with SQL 2005 and SQL 2008 versions. I am really impressed with its features and keyboard shortcuts are similar to VS, so makes the transition really smooth to a new editor.
我已经使用免费软件亚特兰蒂斯SQL Enywhere近6个月了，一直运行得很好。使用SQL 2005和SQL 2008版本。它的特性和键盘快捷键与VS相似，这给我留下了深刻的印象，这让我很容易过渡到一个新的编辑器。
Some of the features that are worth mentioning:
一些值得提及的特性:
- Intellisense that actually works when using multiple tables and joins with aliases
- 当使用多个表和连接别名时，实际工作的智能感知
- Suggestion of joins when using multiple tables (reduces time on typing, really neat)
- 使用多个表时的连接建议(减少键入时的时间，非常整洁)
- Rich formatting of sql code, AutoIndent using Ctrl K, Ctrl D.
- 丰富的sql代码格式，使用Ctrl K, Ctrl D自动缩进。
- Better representation of SQL plans
- 更好地表示SQL计划
- Highlights variables declarations while they are used.
- 使用变量时突出显示变量声明。
- Table definition on mouse hover.
- 鼠标悬停的表定义。
All these features have saved me lot of time.
所有这些特性都为我节省了很多时间。
#7
5
If you are already spending time in Visual Studio, then you can always use the Server Explorer to connect to any .Net compliant database server.
如果您已经在Visual Studio中花费了时间，那么您可以始终使用服务器资源管理器来连接任何符合。net的数据库服务器。
Provided you're using Professional or greater, you can create and edit tables and databases, run queries, etc.
如果您使用的是专业的或更专业的，您可以创建和编辑表和数据库，运行查询等等。
#8
4
There is an express version on SSMS that has considerably fewer features but still has the basics.
SSMS上有一个快速版本，它的功能少得多，但仍然具有基本功能。
#10
1
You can still install and use Query Analyzer from previous SQL Server versions.
您仍然可以安装和使用以前SQL Server版本的查询分析器。
#11
1
Oracle has a free program called SQL Developer which will work with Microsoft SQL Server as well as Oracle & MySQL. When accessing SQL Server, however, Oracle SQL Developer is only intended to enable an easy migration to Oracle, so your SQL Server database is essentially read-only.
Oracle有一个名为SQL Developer的免费程序，它将与Microsoft SQL Server以及Oracle和MySQL一起工作。然而，在访问SQL Server时，Oracle SQL Developer只打算支持轻松迁移到Oracle，因此SQL Server数据库基本上是只读的。
#12
#1
45
I've started using LinqPad. In addition to being more lightweight than SSMS, you can also practice writing LINQ queries- way more fun than boring old TSQL!
我开始使用LinqPad。除了比SSMS更轻量级之外，您还可以练习编写LINQ查询——比枯燥的旧TSQL更有趣!
#2
18
Seems that no one mentioned Query Express (http://www.albahari.com/queryexpress.aspx) and a fork Query ExPlus (also link at the bottom of http://www.albahari.com/queryexpress.aspx)
似乎没有人提到查询Express (http://www.albahari.com/queryexpress.aspx)和一个fork查询ExPlus(也链接在http://www.albahari.com/queryexpress.aspx的底部)。
BTW. First URL is the home page of Joseph Albahari who is the author of LINQPad (check out this killer tool)
顺便说一句。第一个URL是Joseph Albahari的主页他是LINQPad的作者(看看这个杀手工具)
#3
18
TOAD for MS SQL looks pretty good. I've never used it personally but I have used Quest's other products and they're solid.
SQL女士的癞蛤蟆看起来不错。我从未用过它，但我用过Quest的其他产品，它们很结实。
#4
#5
13
I have been using Atlantis SQL Enywhere, a free software, for almost 6 months and has been working really well. Works with SQL 2005 and SQL 2008 versions. I am really impressed with its features and keyboard shortcuts are similar to VS, so makes the transition really smooth to a new editor.
我已经使用免费软件亚特兰蒂斯SQL Enywhere近6个月了，一直运行得很好。使用SQL 2005和SQL 2008版本。它的特性和键盘快捷键与VS相似，这给我留下了深刻的印象，这让我很容易过渡到一个新的编辑器。
Some of the features that are worth mentioning:
一些值得提及的特性:
- Intellisense that actually works when using multiple tables and joins with aliases
- 当使用多个表和连接别名时，实际工作的智能感知
- Suggestion of joins when using multiple tables (reduces time on typing, really neat)
- 使用多个表时的连接建议(减少键入时的时间，非常整洁)
- Rich formatting of sql code, AutoIndent using Ctrl K, Ctrl D.
- 丰富的sql代码格式，使用Ctrl K, Ctrl D自动缩进。
- Better representation of SQL plans
- 更好地表示SQL计划
- Highlights variables declarations while they are used.
- 使用变量时突出显示变量声明。
- Table definition on mouse hover.
- 鼠标悬停的表定义。
All these features have saved me lot of time.
所有这些特性都为我节省了很多时间。
#6
#7
5
If you are already spending time in Visual Studio, then you can always use the Server Explorer to connect to any .Net compliant database server.
如果您已经在Visual Studio中花费了时间，那么您可以始终使用服务器资源管理器来连接任何符合。net的数据库服务器。
Provided you're using Professional or greater, you can create and edit tables and databases, run queries, etc.
如果您使用的是专业的或更专业的，您可以创建和编辑表和数据库，运行查询等等。
#8
4
There is an express version on SSMS that has considerably fewer features but still has the basics.
SSMS上有一个快速版本，它的功能少得多，但仍然具有基本功能。
#9
#10
1
You can still install and use Query Analyzer from previous SQL Server versions.
您仍然可以安装和使用以前SQL Server版本的查询分析器。
#11
1
Oracle has a free program called SQL Developer which will work with Microsoft SQL Server as well as Oracle & MySQL. When accessing SQL Server, however, Oracle SQL Developer is only intended to enable an easy migration to Oracle, so your SQL Server database is essentially read-only.
Oracle有一个名为SQL Developer的免费程序，它将与Microsoft SQL Server以及Oracle和MySQL一起工作。然而，在访问SQL Server时，Oracle SQL Developer只打算支持轻松迁移到Oracle，因此SQL Server数据库基本上是只读的。