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!!!
[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 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)
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.
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.