IdealSqlTracer icon
IdealSqlTracer icon

IdealSqlTracer

IdealSqlTracer is a simple, free, open source alternative to SQL Profiler that formats all of the sql behind a web page or desktop app. It puts the formatted sql in notepad so that you can easily copy it to SSMS.

First dialog screen asks for domain name if using active directory

Cost / License

  • Free
  • Open Source

Application type

Platforms

  • Windows
Second dialog screen asks you to select server
Third dialog screen requests that select database
+3
Fourth dialog screen allows you to specify filters
Alternatives  
1like
3alternatives
0articles

Features

IdealSqlTracer News & Activities

Highlights All activities

Recent activities

Ad
Screenshot
Grist icon
Grist

Transform data with an open-source interface using relational databases and Python engines. Collaborate in real-time with custom permissions for security.

 
Learn More

IdealSqlTracer information

GitHub repository

  •  1 Stars
  •  0 Forks
  •  0 Open Issues
  •   Updated  
View on GitHub

Popular alternatives

View all

Our users have written 1 comments and reviews about IdealSqlTracer, and it has gotten 1 likes

IdealSqlTracer was added to AlternativeTo by harvey007y on and this page was last updated .

Comments and Reviews

   
Top Negative Comment
Chermy Mobix
0

useless and discontinued.

Featured in Lists

Webmaster tools

A list with 50 apps by h0rr0rh0und without a description.

List by Christina Plowman with 50 apps, updated

Official Links

AppStores & Other Links

What is IdealSqlTracer?

IdealSqlTracer is a simple, free, open source alternative to SQL Profiler. The advantage of IdealSqlTracer is that it takes all of the sql generated behind the scenes in a desktop application or web page, and it formats it to make it easily readable. IdealSqlTracer takes this beautifully formatted sql, and puts it into notepad. This allows you to easily cut-n-paste the sql in notepad, and run it directly in Sql Server Management Studio (SSMS). The advantage of doing this is that it makes it possible for you to see exactly what is going on in your application or website. IdealSqlTracer utilizes sp_trace_create, sp_trace_filter, sp_trace_setstatus sql procs to create these custom traces for you.

Steps to use:

  1. Download source for IdealSqlTracer at https://github.com/harvey007y/IdealSqlTracer
  2. Build and Run IdealSqlTracer
  3. A series of dialog boxes will appear that allow you to specify the server, database, username, password, and so on.
  4. Once the basic info is entered, a green dialog box is displayed telling you the trace has started. That dialog tells you that you need to perform the action on the website that you want to trace. After the action on the website is done, click the okay button in the green dialog box to end the trace and have the formatted sql appear in notepad. The next screenshot shows the green dialog box that pops up when I am trying to trace what is going on behind a desktop app called IdealAutomate. After the green box appears, I hit save in the IdealAutomate application to cause some sql to be generated.

IdealSqlTracer Videos