Trc2Sql.exe - Save SQL Trace File as SQL Script

version: 1.0.0.1

last updated: 13 April 2005

platform: MSDE 2000 and SQL Server 2000 running Windows NT 4.0 and higher

Description:

Trc2Sql save a SQL Server 2000 trace file as a .SQL script file, which than can be opened and executed by for example SQL Query Analyzer.

Note: This tools provides the same resulting .SQL script file as when using the SQL Profiler UI (FileðSave AsðSQL Script).

Usage:

Trc2Sql.exe version 1.0x1

Trc2Sql usage:

-i input file
-o output file

-u Unicode output file format

-v version information
-? command line usage

Sample output:

Save SQL Server 2000 trace file as .SQL file.

Trc2Sql -i c:\temp\trace.trc -o c:\temp\trace.sql
 

Installation:

Simply copy "Trc2Sql.exe" onto your machine; preferred location is the "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" directory, but it can be installed in any directory, as long as the "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" direct is on the PATH.

Download: Trc2Sql.zip

Requirements:

1. The SQL Server 2000 client tools need to be installed.

2. The "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" needs to be on the PATH (default when SQL Server 2000 Client Tools are installed)

Planned functionality enhancements:

• None
   

• Other suggestions, ideas, please send email to ideas

Questions or problems regarding this web site should be directed to Web Master.
Copyright © 1991-2005 SQLDev.Net. All rights reserved.
Last modified: 04/06/05.