Best Database Management Tools

05/15/2012 23:26 shadowman123#16
well i searched About MsSql So i FOund MsSql Server 2012 So what i understood from searching that I gotta install MsSQl Server 2012 And i must make MsSql Reader using Datasets .. So is that Enough to Work With MsSql Database ?
05/15/2012 23:55 Mashkin#17
I am using Navicat Premium and I really like it due to its functionality, handling,
and most notably, its support for multiple types of databases - in fact all common ones, like MySQL, SQL Server, PostgreSQL, Oracle DBs and SQLite files.

However, it is not really cheap (250$ non-commercial). Luckily, I may share a license with a relative (IT administrator).

It just gives you power over all the database types mentioned above while keeping a unified front-end.

You could probably reach the same luxury with getting yourself the stand-alone free versions for the different database types (so far, the free editions have been removed).


Talking about PhpMyAdmin, first of all, it is limited to managing MySQL databases.
But even worse is the fact that it is web based. This - for my purposes - makes it fall out of range when selecting a databse tool for "serious work".

However, it is still an option when it comes to shared hosting and any scenario where a user should not access the database directly.
05/15/2012 23:59 shadowman123#18
Quote:
Originally Posted by M@shkin View Post
I am using Navicat Premium and I really like it due to its functionality, handling,
and most notably, its support for multiple types of databases - in fact all common ones, like MySQL, SQL Server, PostgreSQL, Oracle DBs and SQLite files.

However, it is not really cheap (250$ non-commercial). Luckily, I may share a license with a relative (IT administrator).

It just gives you power over all the database types mentioned above while keeping a unified front-end.

You could probably reach the same luxury with getting yourself the stand-alone free versions for the different database types (so far, the free editions have been removed).
Well im using Navicat Enterprise Edition 8.2 So Surely Premium is Much Better ..Anyways Ill Try PhpMyAdmin , Mysql managment Studio and Find which is better for Me

Thx Alot All of You Guyz ..
05/16/2012 09:48 I don't have a username#19
Microsft Sql Management Studio, since I'm using Mssql ^_^

For Mysql, then I'd say phpmyadmin, because it's easy to use and I've always been used to work with that. IMO I find phpmyadmin > Navicat.

I don't like too much changes regarding applications and management, because I like to work the same way as I've always done, unless it's really necessary learning a new way of doing things, then I won't.