QA Alternatives  
Author Message
DRchitectureDSign





PostPosted: Sun Apr 15 02:30:32 CDT 2007 Top

SQL Server >> 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 ....

SQL Server5  
 
 
Uri





PostPosted: Sun Apr 15 02:30:32 CDT 2007 Top

SQL Server >> QA Alternatives 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 ....









>
> 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 ....
>
>
>


 
 
jbellnewsposts





PostPosted: Sun Apr 15 03:08:02 CDT 2007 Top

SQL Server >> QA Alternatives Hi Liz/Uri



> 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!



> >
> > 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
 
 
Uri





PostPosted: Sun Apr 15 04:03:56 CDT 2007 Top

SQL Server >> QA Alternatives 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?










> Hi Liz/Uri
>

>
>> 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!
>


>> >
>> > 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


 
 
jbellnewsposts





PostPosted: Sun Apr 15 05:32:02 CDT 2007 Top

SQL Server >> QA Alternatives See inline..



> 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





PostPosted: Sun Apr 15 05:47:30 CDT 2007 Top

SQL Server >> QA Alternatives > 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






> See inline..
>

>
>> 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


 
 
Liz





PostPosted: Sun Apr 15 12:34:37 CDT 2007 Top

SQL Server >> QA Alternatives


>> 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