Database Management Tools

Anyone who follows me on Twitter will have heard my rant today!

I’ve been using SQL Server Management Studio for years and have become spoilt by a decent product. PostgreSQL and MySQL database tools seem to fall under one category - Pants.

Just wondering what database tools people use out there - there has to be 1 good one out there!!!

I have been very happy with RazorSQL.

Navicat

I use for SQLite :
MesaSQLite
SQLite Database Browser
SQLiteStudio

[quote=89774:@Patrick Delaney]…
I’ve been using SQL Server Management Studio for years and have become spoilt by a decent product. … [/quote]

I don’t know of anything that comes close to it. But now I use navicat for general purpose and data transfers, plus various database engine specific tools - but MS SQL Server was and is rock solid software. I have been using it for 25 years. (My first SQL server box had the names of Sybase, Microsoft and - if I remember right - Ashton Tate on it, and was running on OS/2 …)

I use for SQLite:
SQLite Expert Professional
SQLite Expert
$59 lots of features.

I have/use a lot of different one
Navicat Premium (all)
SQLVue (sqlite)
robomongo (mongodb)
valentia studio
mdblite (access->sqlite)
cubesql manager (cubesql)
sqlitemanager (sqlite)
sqliteconverter (sqlite)
sqlitedoctor (sqlite)

and the list goes on and on…

For MySQL I’ve been using this for years: http://www.heidisql.com/

Just looking at the website it looks like it may also have support MSSQL and Postgres. I think I’ll update to the latest version and try it out.

Suppose this is where I’m coming from. SSMS is solid, feature full and easy to use.

Every other tool I’ve tried seems flaky/clunky and rough. I’ve been using Valentina studio (Best of a bad bunch) and it’s been crashing 3 times a day!

People above seem to be using multiple tools to maintain/develop one database (correct me if I’m wrong). That’s nuts.

i use the right tool for the right task… and there is no tool that does it all. or not one that I have found.

I use MySql workbench and it seems ok http://www.mysql.com/products/workbench/ and SQLite Professional https://www.sqlitepro.com although the latter does have some minor bugs if pushed it does what I need it to do.

I guess it depends what features you need.

For MYSQL i’ve been using SQLYog for years and really like it…

Navicat Premium for me, and the latest version, 11 also supports Maria DB which is a drop in replacement for MySQL but with simpler licensing. I also use RazorSQL, but for me Navicat is a very polished (but not cheap) product. http://www.navicat.com/products/navicat-premium.

It allows you to connect to MySQL, MariaDB, SQL Server, SQLite, Oracle and PostgreSQL databases simultaneously which I find useful for syncing data and structure across different database types.

Any interest in a community-developed, open-source tool? Would people have time to work on it?

Since such projects tend to die on the vine, someone would have to take the lead. That someone won’t be me, although I’d be happy to contribute.

Tried/bought many others, never looked back after finding Navicat.

I also tried several tools and and now use, with great satisfaction, both SqliteManager and Navicat Premium Essentials.
I also use Mdblite if I need to quickly convert MS Access db to Sqlite.

I wrote my own db admin software for SQLite.

For MySQL the free SequelPro:
http://www.sequelpro.com

Valentia Studio for MySQL, PostgreSQL and sqlite http://www.valentina-db.com/en/valentina-studio-overview
It’s free ad cross-platform

[quote=90034:@Kirill Pekarov]
It’s free ad cross-platform[/quote]
It’s free aNd cross-platform