Post reply

SQL Server Management Studio Query Analyzer Replacement

  • October 27, 2015 at 11:25 am

    #312596

    Hi

    probably a question asked a hundred times, apologies..

    My internet host used SQL Server 2000 but recently upgrade to 2008. I managed the old DB (very comfortably!) with a combination of and Access Data Project (ADP) and Query Analyzer which was installed and permanently usable free from a trial package of SQL Server 2000 (I think that's right).

    Seems I can't use an ADP any more and nor can I use my old Query Analyzer and I need to use SQL Server Management Studio. Is there a way of getting the equivalent of the free Query Analyzer but for SQL Server Management Studio?

    Alternatively, I wouldn't mind stepping out of the Microsoft environment altogether and maybe getting another ODBC tool that would enable me to manage my online DB if anyone knows one?

    Thanks for any thoughts/suggestions..

    Pavesa

  • October 27, 2015 at 11:34 am

    #1835864

    What does Query Analyzer provide that SQL Management Studio does not?

    There are many third party tools available, Toad is one of the more popular ones.

    And, I'm not sure I have ever heard this question asked. Certainly not 100 times!:-D

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • October 27, 2015 at 11:34 am

    #1835865

    You can either download the last version of SQL Server Management Studio which is "standalone". https://msdn.microsoft.com/en-us/library/mt238290.aspx

    Or you can download an express version of SQL Server which includes it (be sure it says with tools or advanced tools).

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 27, 2015 at 11:53 am

    #1835870

    Andrew Bagley (10/27/2015)

    ... nor can I use my old Query Analyzer and I need to use SQL Server Management Studio.

    I'm still using Query Analyzer (against SQL2008 and SQL1012). Personally I don't like the keyboard mapping/interaction of the editor in SSMS, so I have stuck with Query Analyzer, so I reckon you should still be able to connect that to new versions of SQL.

    I use the Client Network Utility to set up an ALIAS for the target server (basically a Nickname and an IP address, or a DNS name), and then connect to that NickName in Query Analyzer

    EDIT: I set up my ALIASes using TCP/IP, and NOT Named Pipes

  • October 27, 2015 at 12:18 pm

    #1835871

    Hi

    thanks for the info and glad to hear that I'm not boring everyone with the hundredth post on this!

    I've actually only just found out about the issue as my daily routine involves just running copy queries on the DB and these work fine with both ADP and Query Analyzer. It's only because I thought I might need to edit a query and checked it (luckily I didn't) that I encountered the issue.

    One great thing about Query Analyzer was that it was free forever from the trial installation package and it looks like the express version of SQL Server has the same so that sounds great.

    I've also seen a product called HeidiSQL and another called EMS SQL Manager Lite for SQL Server and I wonder if anyone has used either of these and could comment on them. I don't mind at all stepping out from the Microsoft stuff - I've encountered huge undocumented issues with backward compatibility over the years (this is the latest of many many occurrences) and I'd be pleased to say goodbye if I can find something else that does the job for editing table properties and queries.

    Thanks for any thoughts..

  • October 27, 2015 at 12:22 pm

    #1835874

    You mentioned that you are managing the database. Of course you can do everything you need using T-SQL from a query window, but going with any other tool (like MS Access, Query Analyzer 2000, FlySpeed SQL, Oracle SQL Developer, etc.) you're going to miss out on database management related functionality in the GUI.

    There is a free and portable (no install) tool called FlySpeed that I've used on occasion, which is ok for querying and navigating databases / objects. I keep it on my thumbdrive for those occasions where I need database access and SQL Server client tools aren't installed. In addition to SQL Server, it also supports several different RDMS, including Oracle and MySQL. It comes in handy, if you're a consultant wearing a lot of hats.

    http://www.activedbsoft.com/overview-querytool.html

    There is also Oracle SQL Developer, which is free and supports Oracle, SQL Server, and I think a few more RDMS. I used this tool a lot back when I was working with Oracle more on a regular basis. It's cross platform (Windows, Linux, Mac) and requires Java runtime. It's solid, but won't give you same DBA support in GUI as SSMS.

    http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

    Honestly, unless you need cross-RDMS or cross-OS support, I can't think of a strong and compelling reason to use anything other than Microsoft's SSMS, which is part of free client tools download.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • October 27, 2015 at 4:04 pm

    #1835908

    Hi

    thanks very much for all the thoughts on this. Several tools to think about and investigate but probably SSMS is the rational way to go..

    Cheers

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply