Vaibhav_joshi
asked on
Easy tool to create SQL queries ?
I want to access Mssql database on my webserver (provided by bluehost) and extract some reports. Is there any tool which I can install on my local machine which can connect to this web server and run queries ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'd recommend MySQL workbench http://dev.mysql.com/downloads/workbench/
or Crystal Reports, depends what you need it for...
or Crystal Reports, depends what you need it for...
navicat.com offers a nice SQL query tool. It isn't free but it does come with a 30-day trial if you want to give it a go. Pricing for the MySQL version is currently $129.00 (or $99.00 if it is for non-commercial purposes.)
ASKER
Can navicat connect to remote SQL databases on internet server ?
ASKER
Navicat seems to be interesting. I will try free version for few days first.
EMS MySQL Manager — nice interface, visual query builder, multiple database connections, import and export features, SQL query editor with code highlighting, great stuff :)
http://www.sqlmanager.net/products/mysql/manager
There is a Freeware version with very acceptable limitations.
http://www.sqlmanager.net/products/mysql/manager
There is a Freeware version with very acceptable limitations.
ASKER
not easy solution
ASKER