SQL SERVER - SQL/Query tools?

I haven't really done a ton of database work in a few years and have become unaccustomed with the tools available. Back a few years ago I was working with oracle databases and was using primarily TOAD with a little bit of MS Access as my tools of choice to prototype the queries I was using in my applications. I really loved TOAD in that it was super intuitive and really easy to use and I'm hoping to find something similar for MS SQL Server. Something open source or free is preferable, since I doubt my client will want to pay for anything, but I'm willing to hear suggestions of things that cost money if they are far and away the best in class tool available.

This question and answers originated from www.stackoverflow.com
Question by (8/20/2008 2:18:10 PM)

Answer

Maybe try SQL Manager Express first. If you need more, you can always look for other solutions.

Edit: This was for MS SQL 2005 Express. I hope that there will be a new one for MS SQL Express 2008, and it will be much quicker like VS 2008 compared to VS 2005.

Answer by
Find More Answers
Related Topics  sql-server  oracle  query  tools  toad
Related Questions

  • are there any Query Optimization Tools for SQL Server?

    are there any tools that do Query Optimizations for SQL Server 2005 and above? i've searched & didnt find anything what do you recommend? if this Question was repeated before you can cl…

  • Tools to convert sql query to linq

    I write sql query for many year but I am new to linq. Are there any tools to convert sql query to linq(especially linq to entity) so as that I can learn linq faster?

  • Alternative to SQL Tools and Toad IDEs for Oracle query development

    Are there any better alternatives to using SQL Tools and TOAD for writing stored procs and queries for Oracle DB? Better in the sense of being able to debugg large queries and stored procedures. …

  • Free SQL Server tools

    Anyone have an update to date list of Free administrative Tools for SQL Server. There is a forum post on SQLServerCentral but its pretty outdated. Please provide a link as some vendors do a prett…

  • Redgate SQL Tools

    I am testing the Redgate belt and the set of tools seems pretty amazing... but before I buy anything... could you recommend any other tools similar to these? Thanks

  • .net sql query logging using SSMS Tools pack

    I have just installed SSMS tools pack from http://www.ssmstoolspack.com everything seems to work except I cant view queries from my .net application. If I run a query through management studion SSMS…

  • Tools and techniques to optimize a LINQ to SQL query

    I have a couple of LINQ to SQL queries that I feel take a lot of time. What tool and techniques can I use to first find out: How long they take and if there is room for improvement ? Find out…

  • Complicated SQL Query

    I am trying to make a sql query following these rules: basically i have 2 parent tables, A and B. B has a child table called C and A has a child called D. when i select a value from B i get a ran…

  • SQL Server Stress Test Tools?

    I am looking for a stress tool for SQL Server. I've seen a lot of suggestions on Google. But nothing of what I really need. I look for: I really look for a tool that could run a list of stored…

  • Red Gate's SQL Toolbelt or Quest's Toad for SQL Server?

    We are evaluating trial versions of Red Gate’s SQL Toolbelt and Quest Software’s Toad for SQL Server. What are the main differences between these tools? The benefits of using these tools are quite o…