No Query Analyzer with MSDE?

[blabore]

I'm a little confused about MSDE. It appears that the downloaded version of MSDE doesn't come with any of the supporting tools, such as Query Analyzer. However, the CD version of MSDE that ships with the full verions does. Most of my clients don't want to shell out the 1500 for the full version, and typically use the free MSDE. Since I deploy the database for my application by running several SQL scripts (typically through Query Analyzer), is there a workaround to this? Any help would be appreciated.

[auxcom]

There is a free tool called MSDE Query. I have not used it :-) but I think it will help. Please let me know of what you think of it.

 

http://www.msde.biz/msdequery/download.htm

[blabore]

Looks like a great tool, thanks for the help. I'll check it out and let you know. -Ben

[Nerseus]

It "works" though I would NOT want to use it for very long.

 

Given the built-in features of .NET, you could easily write about 90% of the functionality yourself and have a MUCH nicer tool. For a developer that's familiar with DataSets and binding to a grid, you could do the rewrite in a couple of days and have a LOT more/better functionality.

 

I'm not trying to put down the freebee tool, but you get what you pay for :)

 

Don't forget, if you own Access you can add a linked table (point it to your MSDE database) and run queries in Access. I don't like Access' query tool very much either, but some do.

 

And if you own Visual Studio (not sure which versions include it), you can do DB management and write queries from the Server Explorer. Just add a connection to your MSDE database and there you go!

 

By the way, Whidbey has a lot more and WAY better support for DB functions built in! (Whidbey being the codename for Visual Studio 2005, due out next year).

 

-Nerseus