Acess/SQL tools location

R

RidgeRunner

Where are the tools such as db designer, table designer and query designer
located or obtained. Starting to investigate the task of converting from
Access to SQL and just installed SQL 2000 Server on a test machine. Expected
to find SQL tools that I could install on the client workstation but have not
located them. Any suggestions or guidance would be appreciated. Thanks!
 
M

Mike Labosh

Where are the tools such as db designer, table designer and query designer
located or obtained. Starting to investigate the task of converting from
Access to SQL and just installed SQL 2000 Server on a test machine.
Expected
to find SQL tools that I could install on the client workstation but have
not
located them. Any suggestions or guidance would be appreciated. Thanks!
Click to expand...

For developers, you use the SQL Server CD, run setup, and select the option
for "client tools". That gives them Enterprise Manager, Query Analyzer,
Help files, SQL Profiler, etc, but does not install a SQL Server. Never give
these to an end-user :)

Other important development tools that can be used:

Database Projects in Visual InterDev 6.0
Database Projects in Visual Studio.NET
Visual designers in Visual Studio.NET (From the Server Explorer Window)
Microsoft Access Data Projects (Access 2000 and higher)
--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"
 
Top