Solved

Is There a Query Browser for SQL Server?

Posted on 2006-07-17
23
374 Views
Last Modified: 2010-08-05
I'm moderately experienced developing ASP applications with a MySQL database, and I use the MySQL Query Browser application to examine the schema, try out SQL statements, etc.

I'm taking on a new project that uses SQL Server for the backend db server.  I'm fairly certain I cannot use MySQL Query Browser with a SQL Server system.

My question for you is: what tools are available to me that would deliver the functionality of MySQL Query Browser in a SQL Server environment?  

I don't have rights to administer this database -- in fact, I can't even log in to the machine running SQL Server.  I'm particularly interested in robust open-source tools I can use for examining schema, trying out SQL queries, and the like.

Thanks.
0
Comment
Question by:JohnAtkinson
  • 10
  • 8
  • 4
  • +1
23 Comments
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125362
It's called "Query Analyzer".
0
 

Author Comment

by:JohnAtkinson
ID: 17125371
How do I get my hands on it?  Is it open source?
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125373
Ah, you don't have any DB to connect to? Try this:
http://www.microsoft.com/sql/editions/express/default.mspx
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125379
It's free.
0
 

Author Comment

by:JohnAtkinson
ID: 17125403
Isn't this an entire SQL Server product?  I just need the query tool.
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17125440
Query Analyzer is the interactive tool to connect to SQL Server.
0
 

Author Comment

by:JohnAtkinson
ID: 17125503
How do I get Query Analyzer?
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125509
JohnAtkinson, so you do have a remote DB you can query? If so, you'll need Query Analyzer and such. The tools are free for any licensed DB (I think), so if you get your hands on a SQL CD, you can legally install Tools-Only.

SQL 2005 calls it "SQL Server Management Studio Query Editor".

I suppose you could also get the 180 days trial of SQL 2005 and install only the tools.
0
 

Author Comment

by:JohnAtkinson
ID: 17125560
Yes, my client has a live SQL Server-based web application already.  He doesn't own the servers his website or database reside on -- those belong to the web hosting company.  Therefore, I don't know how to get my hands on the tools I need to begin to study the application's schema.
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17125610
If you can ODBC to the database, won't MySQL Query Browser work with that?
0
 
LVL 26

Accepted Solution

by:
DireOrbAnt earned 500 total points
ID: 17125649
At this point, I would go there:
http://www.microsoft.com/sql/downloads/trial-software.mspx

And get my hand on the trial, not the express. Big download I guess, but I would then only install he tools.

Anybody knows what the licensing is for Tools only?

With all of MSFT tools, you'll be able to play with profilers and such, you might need to do some of that in your contract.
0
 

Author Comment

by:JohnAtkinson
ID: 17125757
jrb1, I don't know how I'd go about ODBCing to the database.  I've got the connection information from the ASP source code.  Where (on which system)  does the ODBC connection get created?
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125958
On your side. What does the connection looks like in ASP? Remove the password of course :)
0
 

Author Comment

by:JohnAtkinson
ID: 17126211
With fake values, it looks like this:

Dim webServer1, webDB, webLogin, webPass
webServer1="SERVERNAME.COM"
webDB="MyOwnDatabase"
webLogin="MyLoginString"
webPass="MyPassword"

ConnStr = "Provider=sqloledb; Server=" & webServer1 & "; Initial Catalog=" & webDB & "; UID=" & webLogin & "; PWD=" & webPass
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17126337
OK, you should be able to add an ODBC connection to SQL Server.  The server is your webServ1.  The database is webDB. Userid and password are obvious. That should be enough to get an ODBC connection.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 17126462
Are we talking about SQL Server 2000 or 2005?
0
 

Author Comment

by:JohnAtkinson
ID: 17126763
I'm afraid I don't know which version of SQL Server this web host is using.
0
 

Author Comment

by:JohnAtkinson
ID: 17126849
jrb1, I was able to configure a User DSN ODBC connection.  (Is User DSN the right kind?)

I tested the connection and the ODBC configuration wizard said it could connect, and it was able to get the default database name, which is encouraging.

What I don't know how to do now is configure the MySQL Query Browser to use the ODBC connection I just made.

Query Browser asks for the following:

Stored Connection: [I tried entering my User DSN here]

Server host: [I tried entering the real webServer1 value from above, which I successfully used to make the ODBC User DSN)

Port: it's sitting at 3306 right now, and I have no idea whether that's appropriate.

Username and password: [these aren't ambiguous -- I used the values I used during ODBC configuration]

Default Schema: [I tried the webDB value from above]

Any advice on how I can use my ODBC connection with the MySQL Query Browser?
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17127593
You should be able to select ODBC on the default connection screen.  If port 3306 doesn't work, you could try the default port of 1433.
0
 

Author Comment

by:JohnAtkinson
ID: 17177155
I installed SQL Server 2005 Express, but I've been unable to locate Query Analyzer.  I didn't want to leave this question open any longer.  Thanks, everyone, for trying to help.  It looks like Query Analyzer is available only to people who buy The Big Boat, and there's no way to get the MySQL Query Browser reach the SQL Server database.

0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17177444
Go back here:
http://msdn.microsoft.com/vstudio/express/sql/download/

And get SQL Server Management Studio Express.

It's also packaged (with other stuff) into: SQL Server 2005 Express Edition with Advanced Services SP1

0
 

Author Comment

by:JohnAtkinson
ID: 17178262
Thanks, again, DireOrbAnt.  I now have what I need!
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17178654
Cool!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question