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
> > What good alternatives are there to SQL Server Query Analyzer ?
> 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!
> "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
There is no lower cost than free! What features do you require?
> >
> > Thanks ...
> >
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:
>> Liz
>> > What good alternatives are there to SQL Server Query Analyzer ?
>> 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!
>> "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
> There is no lower cost than free! What features do you require?
>> >
>> > Thanks ...
>> >
> John|||See inline..
"Uri Dimant" wrote:
> 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...
That is why I would say look at EM.. but then for querying QA is the better
option
>
> > 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?
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:
>> 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...
> That is why I would say look at EM.. but then for querying QA is the
> better
> option
>>
>> > 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?
> 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...
>> 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.
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