Link to home
Start Free TrialLog in
Avatar of Vaibhav_joshi
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
Avatar of warddhooghe
warddhooghe
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vaibhav_joshi
Vaibhav_joshi

ASKER

Is there any way to create more graphical and easy to create queries.
I'd recommend MySQL workbench  http://dev.mysql.com/downloads/workbench/
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.)
Can navicat connect to remote SQL databases on internet server ?
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.
not easy solution