Third-party database access tools
From a textbook: "A person can access the data by using query or reporting tools that are of the DBMS or by using application programs specifically written to access the data."
Please give two examples of application programs specifically written to access the data.
(in SQL Server).
Please give two examples of application programs specifically written to access the data.
(in SQL Server).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
jaLouden
Actually Surendra Ganti is right on the money with his answer :)
Seems like an assignment question to me ?
The first one is SQL Server Management Studio which is usually used as an Admin interface but you can also do SQL queries with it. http://en.wikipedia.org/wiki/SQL_Server_Management_Studio
@jonmarsh44
What is it that you don't understand ?
While we cannot give you the answer, we can certainly help resolve any misunderstanding or confusion.
What is it that you don't understand ?
While we cannot give you the answer, we can certainly help resolve any misunderstanding or confusion.
ASKER
I'm truly surprised. No, this is not a homework assignment; there is no academic dishonesty going on here. I'm a newbie to databases. I don't think I phrased my question correctly.
One response said: "There are many 3rd party tools that will do it as well. Toad for SQl by Quest, and squirrel can be used to test all sorts of jDBC drivers to a sql server." That's very close to the answer I was hoping for but I cannot visualize how , for example, Toad, accesses the data.
What happens? Is it that when you install Toad part of the installation requires you to recognize that SQL Server is there? How does Toad know that a SQL Server database is on the hard drive? (I also can't visualize testing jDBC drivers but I'll do with an answer just for Toad.) After all, my professor might get suspicious.
Just kidding!
One response said: "There are many 3rd party tools that will do it as well. Toad for SQl by Quest, and squirrel can be used to test all sorts of jDBC drivers to a sql server." That's very close to the answer I was hoping for but I cannot visualize how , for example, Toad, accesses the data.
What happens? Is it that when you install Toad part of the installation requires you to recognize that SQL Server is there? How does Toad know that a SQL Server database is on the hard drive? (I also can't visualize testing jDBC drivers but I'll do with an answer just for Toad.) After all, my professor might get suspicious.
Just kidding!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I still recommend Microsoft's SQL Server Management Studio as the first SQL tool you should have. It performs both the admin functions and SQL queries for a server. Also allows several connection methods and can be used with remote servers too.
ASKER
Thanks to all. In particular, thank you Mr. Horn for your informative - and humorous - comments. I shall comply.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.