Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 171
  • Last Modified:

Looking for Microsoft SQL tools

Hi,

I am looking for some Micrisoft  SQL server tools (hopefully free or very cheap ones).  Tools that come with the DB are fine as well (I just don't know about them)

I am working on a control system that uses this database and I want to poke around the DB and see how things are stored, so I would like tools that will help me to poke around and discover things in the DB.

In some cases, I want to look at the word data directly.

Thanks in advance

0
Christopher Schene
Asked:
Christopher Schene
  • 6
  • 3
  • 2
  • +1
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
cschene,
>  I want to poke around the DB and see how things are stored

For this Enterprise manager is sufficient
0
 
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
> For this Enterprise manager is sufficient

How do I obtain this? Is it free?
0
 
SireesCommented:
You can get SQL Server 2005 express edition for free

http://msdn.microsoft.com/vstudio/express/sql/download/
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LowfatspreadCommented:
>>I am working on a control system that uses this database and I want to poke around the DB and see how things are stored, so I would like tools that will help me to poke around and discover things in the DB.


You shouldn't be poking around in the DATABASE

that's What specifications and  Database MODELs are there for you to use...

0
 
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
I am sort of an SQL server neophyte, so my questions may be very basic.

I obtained the SQL server 2005 express edition and SQL server management Studio express. Is there anything else I shoud get?

What can I do with this sw? Is it equivalent functionally to a real server?

I searched for "Enterprise manager" on the net and found many, many references. Which one do I need? One by microsoft?
0
 
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
More specifically, I am attempting to determine how a database is being used and I am back engineering it somewhat.

I am running some programs that access that database and when I change certain items via the program, I want to see what changes in the database.

How would I do this?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
>How would I do this?

You can run the sql profiler and check what sps / functions /Queries are called during the application call . thus you will get a fair idea about this.
0
 
LowfatspreadCommented:
IF it is legal for you to "back engineer" the database
         ====

then i suggest the place to start would be with  a modelling tool and "reverse engineer" the physical database into it
so that  you can begin to attempt to understand the table structures and relationships ...

e.g VISION (microsoft), Powerdesigner (SYBASE), ERWIN (CA) , Rational Rose(IBM?)

0
 
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
You can run the sql profiler and check what sps / functions /Queries are called during the application call . thus you will get a fair idea about this.
==========================================
I looked on my server (which is using microsoftsql) and I found the following programs with sql in the name

sqlchk.exe, sqldbreg.exe, sqlrep.exe, sqlrpt.exe, strt_sql.exe, isql.exe, osql.exe, sqldiag.exe, sqlmangr.exe, sqldiag.exe, sqlmaint.exe, sqlserver.exe

Which of these programs (if any) is a profiler?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\profiler.exe

U can run it from start->programs->MsSql server-> profiler
0
 
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
Comment from Sirees
Date: 05/24/2006 11:58AM PDT
 Comment  


You can get SQL Server 2005 express edition for free
ttp://msdn.microsoft.com/vstudio/express/sql/download/
========================
I did get this (thanks for the information): I assume the tools that come with this will not work with microsoft sql server. The express edition seems like a great learning platform.
 
0
 
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
then i suggest the place to start would be with  a modelling tool and "reverse engineer" the physical database into it
so that  you can begin to attempt to understand the table structures and relationships ...

e.g VISION (microsoft), Powerdesigner (SYBASE), ERWIN (CA) , Rational Rose(IBM?)

===================================================================
Are any of these free? How would I obtain them?
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 6
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now