SQL/查询工具？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18075/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL/Query tools?
提问by shsteimer
I haven't really done a ton of database work in a few years and have become unaccustomed with the tools available. Back a few years ago I was working with oracle databases and was using primarily TOAD with a little bit of MS Access as my tools of choice to prototype the queries I was using in my applications. I really loved TOAD in that it was super intuitive and really easy to use and I'm hoping to find something similar for MS SQL Server. Something open source or free is preferable, since I doubt my client will want to pay for anything, but I'm willing to hear suggestions of things that cost money if they are far and away the best in class tool available.
几年来我并没有真正完成大量的数据库工作，并且对可用的工具变得不习惯。几年前，我在使用 oracle 数据库，并且主要使用 TOAD 和一点 MS Access 作为我选择的工具来原型我在我的应用程序中使用的查询。我真的很喜欢 TOAD，因为它非常直观且非常易于使用，我希望为 MS SQL Server 找到类似的东西。开源或免费的东西更可取，因为我怀疑我的客户是否愿意为任何东西付费，但如果它们是可用的同类最佳工具，我愿意听取有关花钱的建议。
采纳答案by Biri
Maybe try SQL Manager Expressfirst. If you need more, you can always look for other solutions.
也许先尝试SQL Manager Express。如果您需要更多，您可以随时寻找其他解决方案。
Edit: This was for MS SQL 2005 Express. I hope that there will be a new one for MS SQL Express 2008, and it will be much quicker like VS 2008 compared to VS 2005.
编辑：这是针对 MS SQL 2005 Express 的。我希望 MS SQL Express 2008 会有一个新的，并且与 VS 2005 相比，它会像 VS 2008 一样快得多。
Update: MSSQL 2014 Developer Edition is free for development purposes. It contains SQL Manager with full funcionality.
更新：MSSQL 2014 开发人员版可免费用于开发目的。它包含具有完整功能的 SQL 管理器。
回答by nakro
azure_ardee, i've looking for the Windows Authentication on Squirrel. If you use the jtds driver you cand add the property DOMAIN to the connection string.
azure_ardee，我在 Squirrel 上寻找 Windows 身份验证。如果您使用 jtds 驱动程序，您可以将属性 DOMAIN 添加到连接字符串。
The sintax for the conn str is: jdbc:jtds:sqlserver://[:<1433>]/[;=[;...]]
conn str 的语法是： jdbc:jtds:sqlserver://[:<1433>]/[;=[;...]]
For example: jdbc:jtds:sqlserver://hostname:1433/db_name;DOMAIN=my_domain
例如：jdbc:jtds:sqlserver://hostname:1433/db_name;DOMAIN=my_domain
Also, you can click the Properties button, check the DOMAIN property and fill the value with the domain name.
此外，您可以单击“属性”按钮，检查 DOMAIN 属性并用域名填充值。
I hope i helped!
我希望我有所帮助！
Nakro
纳克罗
回答by jason saldo
I like Aqua Data Studio. It's Java but don't be turned off, it performs very well.
我喜欢Aqua 数据工作室。它是Java，但不要关闭，它的性能非常好。
回答by lomaxx
There's also SQL Promptfrom Redgate which has more bells and whistles than you can poke a stick at (MSSQL Only and it's not free)
还有来自 Redgate的SQL Prompt，它有更多的花里胡哨的东西（仅限 MSSQL，它不是免费的）
At the other end of the spectrum is the completely barebones Query Express
在频谱的另一端是完全准系统的Query Express
回答by John Smithers
I haven't used them, but they are free and they claim to be DBMS-independent:
http://www.isqlviewer.com/
http://www.sql-workbench.net/index.html
我没有使用过它们，但它们是免费的，并且声称与 DBMS 无关：
http: //www.isqlviewer.com/
http://www.sql-workbench.net/index.html
回答by samjudson
Well if you liked TOAD then there TOAD supports that too.
好吧，如果您喜欢 TOAD，那么TOAD 也支持这一点。
回答by Lloyd
Developers in our office are starting to use the free SQLDevolper tool by Oracle (http://www.oracle.com/technology/products/database/sql_developer/index.html). I am still very happy with PL/SQL Developer (http://allroundautomations.com/). Both have a minor learning curve, as does TOAD, but once you get the feel of them it's hard to imagine going back to the SQL Worksheet prompt.
我们办公室的开发人员开始使用 Oracle 提供的免费 SQLDevolper 工具 ( http://www.oracle.com/technology/products/database/sql_developer/index.html)。我对 PL/SQL Developer ( http://allroundautomations.com/)仍然很满意。两者都有一个小的学习曲线，TOAD 也是如此，但是一旦你对它们有了感觉，就很难想象回到 SQL 工作表提示。
回答by stevechol
Oracle SQL Developer is very good and also works with SQL Server. You could also try DB Solo 3. Both of these are cross platform applications.
Oracle SQL Developer 非常好，也适用于 SQL Server。您也可以尝试 DB Solo 3。这两个都是跨平台应用程序。
回答by Devart
We offer a nice visual query building tool, called dbForge Query Builder for SQL Server.
我们提供了一个很好的可视化查询构建工具，称为dbForge Query Builder for SQL Server。
回答by Brad Wery
QweryBuildersupports both SQL Server and Oracle. There is also a free Expressversion available.
QweryBuilder支持 SQL Server 和 Oracle。还有一个免费的Express版本可用。
