database 您最喜欢的数据库客户端工具
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1102505/
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
Your favourite database client tool
提问by 7wp
Wondering what is the best or most popular database client tool. Similar to Microsoft's SQL management studio, but one that can work with various databases. Other tools I have found are:
想知道最好或最受欢迎的数据库客户端工具是什么。类似于 Microsoft 的 SQL 管理工作室，但可以处理各种数据库。我发现的其他工具是：
Some of these tools can even compare and sync database schema's and some cases the data itself as well. Very useful when deploying applications for example from a pre-production environment to production environment.
其中一些工具甚至可以比较和同步数据库架构，在某些情况下还可以比较和同步数据本身。例如在从预生产环境到生产环境部署应用程序时非常有用。
So what's your favourite database manager ? Maybe there is a nice open source tool out there that is well rounded with the most useful features.
那么你最喜欢的数据库管理器是什么？也许有一个很好的开源工具，它具有最有用的功能。
采纳答案by Daniel Rikowski
回答by kevinw
SqlDbx - www.sqldbx.com - has a free edition, is portable and works with quite a few dbs.
SqlDbx - www.sqldbx.com - 有一个免费版本，是可移植的并且可以与相当多的数据库一起使用。
Also AnySQL Maestro - http://www.sqlmaestro.com/products/anysql/maestro/
还有 AnySQL Maestro - http://www.sqlmaestro.com/products/anysql/maestro/
回答by Cyril Gandon
I use PL/SQL Developer, as soon as I have to work on an Oracle Database. I like the UI, simple and fast.
一旦我必须在 Oracle 数据库上工作，我就会使用PL/SQL Developer。我喜欢 UI，简单而快速。
回答by penguintux
回答by Mark Harrison
SQL Developer is nice for Oracle and has plugins for several other databases.
SQL Developer 非常适合 Oracle 并且具有用于其他几个数据库的插件。
http://www.oracle.com/technology/products/database/sql_developer/index.html
http://www.oracle.com/technology/products/database/sql_developer/index.html
回答by Csaba_H
Eclipse Data Tools Platformwithin Eclipse (my primary IDE):
Eclipse 中的 Eclipse 数据工具平台（我的主要 IDE）：
- Open source, works with many databases
- Do all the basics and some advanced stuff. In recent versions you can find some kind of visual query builderas well.
- Oracle has a pluginwhere implemented some Oracle-specific functions.
回答by Grzegorz Oledzki
DbVisualizer- there's a free version with a bit limited functionality and a fully fledged one for $149.
DbVisualizer- 有一个功能有限的免费版本和一个完全成熟的版本，售价 149 美元。
回答by Cromulent
I use Navicat myself. It supports MySQL, PostgreSQL and Oracle.
我自己使用 Navicat。它支持 MySQL、PostgreSQL 和 Oracle。
回答by Tom Morris
If you are using PostgreSQL (and, really, you should be!), PgAdminrocks. It lets you query, explore tables, do administrative tasks, manage users, visually explain complex queries, graphically build queries and much more. It runs on Windows, Linux and OS X and can connect to local or remote PostgreSQL servers.
如果您正在使用 PostgreSQL（而且，真的，您应该使用！），PgAdmin 会很棒。它使您可以查询、浏览表、执行管理任务、管理用户、直观地解释复杂查询、以图形方式构建查询等等。它在 Windows、Linux 和 OS X 上运行，可以连接到本地或远程 PostgreSQL 服务器。
回答by Andreas Grech
If your're using MS Sql Server, try using LinqPad; it's much more lightweight than the Management Studio, and you'll be practicing writing queries in linq in the meantime as well.
如果您使用的是 MS Sql Server，请尝试使用LinqPad；它比 Management Studio 轻得多，同时您还将练习在 linq 中编写查询。
(source: linqpad.net)
（来源：linqpad.net）
