QA Alternatives

What good alternatives are there to SQL Server Query Analyzer ? I'm
especially interested in lower-cost ones but would be interested in hearing
about anything good
Thanks ...
Liz

> What good alternatives are there to SQL Server Query Analyzer ?
To upgrade to SQL Server 2005 and have an Object Explorer :-)))
I think you came from Oracle area , so there is no good alternatives SQL
Server Query Analyzer ...
"Liz" <liz@.tiredofspam.com> wrote in message
news:OtQsNnyfHHA.4552@.TK2MSFTNGP04.phx.gbl...
> What good alternatives are there to SQL Server Query Analyzer ? I'm
> especially interested in lower-cost ones but would be interested in
> hearing about anything good
> Thanks ...
>
>
|||Hi Liz/Uri
"Uri Dimant" wrote:

> Liz
>
> To upgrade to SQL Server 2005 and have an Object Explorer :-)))
But Object Explorer is also available in QA!!! F8 works in both QA and SQL
Server Management Studio In SSMS the object explorer does incorporate
functionality in Enterprise Manager... so maybe Liz should take a look at
that?

> I think you came from Oracle area , so there is no good alternatives SQL
> Server Query Analyzer ...
Did I miss something... Oracle and good tools are not two phrases I would
expect in the same sentence... Oracle and the requirement for third party
tools seems to be the norm!
[vbcol=seagreen]
> "Liz" <liz@.tiredofspam.com> wrote in message
> news:OtQsNnyfHHA.4552@.TK2MSFTNGP04.phx.gbl...
There is no lower cost than free! What features do you require?
[vbcol=seagreen]
John
|||Hi John
> But Object Explorer is also available in QA!!! F8 works in both QA and SQL
> Server Management Studio In SSMS the object explorer does incorporate
> functionality in Enterprise Manager... so maybe Liz should take a look at
> that?
Right, but in Object Explorer ( As you press New Query) in SQL Server 2005
you can see all registered servers and as result jobs,mp...

> Did I miss something... Oracle and good tools are not two phrases I would
> expect in the same sentence... Oracle and the requirement for third party
> tools seems to be the norm!
Sorry, what I meant was as an analog of QA in SQL Server , you have to buy
or free download (SQL Developer as I remeber well) a tool to query the
database,
am I right John?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3F20D1A0-32D4-4489-BF5E-B2F6D62CE117@.microsoft.com...
> Hi Liz/Uri
> "Uri Dimant" wrote:
> But Object Explorer is also available in QA!!! F8 works in both QA and SQL
> Server Management Studio In SSMS the object explorer does incorporate
> functionality in Enterprise Manager... so maybe Liz should take a look at
> that?
> Did I miss something... Oracle and good tools are not two phrases I would
> expect in the same sentence... Oracle and the requirement for third party
> tools seems to be the norm!
>
> There is no lower cost than free! What features do you require?
>
> John
|||See inline..
"Uri Dimant" wrote:

> Hi John
> Right, but in Object Explorer ( As you press New Query) in SQL Server 2005
> you can see all registered servers and as result jobs,mp...
That is why I would say look at EM.. but then for querying QA is the better
option

>
> Sorry, what I meant was as an analog of QA in SQL Server , you have to buy
> or free download (SQL Developer as I remeber well) a tool to query the
> database,
> am I right John?
I only used SQL*Plus, so QA spoils me!!
I quick Google for "Query Analyzer Alternative" gave
http://discuss.joelonsoftware.com/default.asp?joel.3.180407.9
http://gpoulose.home.att.net/
Toad is a great favourite in the Oracle world so you may want to look at
that http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm
At $50 the SQL 2005 developer edition could be a good investment especially
if you plan to upgrade. SSMS can be used to manage SQL 2000 systems as well
as SQL 2005.
John
|||> At $50 the SQL 2005 developer edition could be a good investment
> especially
> if you plan to upgrade. SSMS can be used to manage SQL 2000 systems as
> well
> as SQL 2005.
Agreed
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A4E9A194-834B-4E97-A5C8-62383BA14AA1@.microsoft.com...
> See inline..
> "Uri Dimant" wrote:
>
> That is why I would say look at EM.. but then for querying QA is the
> better
> option
> I only used SQL*Plus, so QA spoils me!!
> I quick Google for "Query Analyzer Alternative" gave
> http://discuss.joelonsoftware.com/default.asp?joel.3.180407.9
> http://gpoulose.home.att.net/
> Toad is a great favourite in the Oracle world so you may want to look at
> that http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm
> At $50 the SQL 2005 developer edition could be a good investment
> especially
> if you plan to upgrade. SSMS can be used to manage SQL 2000 systems as
> well
> as SQL 2005.
> John
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ebVAju0fHHA.1252@.TK2MSFTNGP04.phx.gbl...[vbcol=seagreen]
What does "one user" mean in SQL Developer ? is it possible to test with
multiple connections ? is this an honor system thing where MS expects you
basically not to deploy for production use ?
So everyone uses QA or Management Studio ? I have SQL2005 but have not
really been able to use it much for time reasons; seems to me some of these
third party tools have some useful features like import/export tools (that
are easier/faster to use than DTS), intellisense, .NET code generation,
schema and data diff tools, synchronization, etc. I'm not unhappy with QA
but I do like to keep an eye out for tools that will make me more productive
Liz