Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Feb 18, 2004

Microsoft SQL Server 2000 command line utilities (Part 1) - Page 2

By Alexzander Nepomnjashiy

bcp - A utility used for the interactive process of bulk coping of data between the SQL Server 2000 instance and data file (format information file should be specified or a default bcp.fmt should be used instead). The bcp utility is the typical example of a "two-way" tool, i.e. copying data "into SQL Server instance" or "out of SQL Server instance" is allowed. Alternatively, bcp can be used for copying data:

  • Between SQL Server instances with different language collations;
  • To or from a view;
  • Returned from a T-SQL query (to data file);
  • Between the Microsoft SQL Server and database servers of other vendors;
  • Between the SQL Servers working on different processor architectures;
  • To or from a database table (including temporary tables);
  • Between databases within one SQL Server instance.

The bcp utility is installed by default to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory.

cdw - The executable for Copy Database Wizard. To copy the database, cdw performs detach and attach processes on the source database to copy the files to the destination. Typically, cdw is used for moving databases and their related information into the clustered, named instance of SQL Server 2000. The cdw utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default .

cmdwrap - This utility is undocumented. The search for any additional information (SQL Server Books OnLine, Microsoft Technet, MSDN) returned no useful information. It seems that this utility does not require any command line parameters and is used internally by the SQL Server setup program. Judging by its name, cmdwrap is probably used for parsing (Input? Output? Or both?) text strings. The cmdwrap utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default .

cnfgsrv - Another undocumented utility (try to run it with /? switch - to receive a set of command line parameters which it accepts). Cnfgsrv is used internally by the SQL Server setup program, during the configuration of your SQL Server computer. The cnfgsrv utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default.

console - A utility used to diagnose backup / restore processes on tape dump devices. The console utility displays information messages during SQL Server databases back up / restore from tape dump devices. The console utility is installed to the \Program Files\Microsoft SQL Server\MSSQL\Binn directory by default.

dcomscm - The COM-component, is used to manage / administer an SQL Server instance and its services state checking. dcomscm - The dcomscm utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default.

distrib - Replication distribution Agent - command prompt utility, which configures and begins a distribution Agent, which moves transactions and snapshot jobs held in the distribution database tables to Subscribers. Huge (!!!) set of command line switches. distrib utility installed by default to the \Program Files\Microsoft SQL Server\80\Com directory.

[http://doc.ddart.net/mssql/sql70/4_dist.htm]

dtsrun - A command line utility used for retrieving, executing, deleting and overwriting packages, previously created with the use of Microsoft Data Transformation Services. The DTS packages, executed by dtsrun can be stored in the Msdb database, a COM-structured storage file or Microsoft Repository. The dtsrun utility is installed to the \Program Files\Microsoft SQL Server\80\Tools\Binn directory by default .

dtsrunui -The executable for the DTS Run utility. DTS Run provides a graphical interface for the dtsrun utility. The dtsrunui utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

dtswiz - The utility for running the Data Transformation Services Import / Export Wizard from a command prompt. Dtswiz can be used for creating DTS packages that import, export or transform data among different ODBC-data sources. The dtswiz utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default .

dw15 - Dw15 provides the ability to send application crash information to Microsoft. This utility was introduced first in SQL Server 2000 Service Pack 3. Dw15 supports applications such as SQL Server 2000 SP3, that ship with Error Reporting technology. Dw15 announces in a user dialog box that an error has occurred; if the user chooses to send the report to Microsoft, it establishes a connection with watson.microsoft.com on port 80 (using HTTP), and then sends the report securely via port 443 (using HTTPS). The dw15 utility is installed to the \Program Files\Microsoft SQLServer\80\Com directory by default.

isql - A utility for interactive Transact-SQL scripts and stored procedures execution. It uses the DB-library for communicating with the database server. isql can be started directly from the operating system command prompt and uses a standard output device (monitor, by default) to display results. isql works as a SQL Server 6.5 level client when connected to SQL Server 2000. The isql utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

isqlw - The executable for SQL Server Query Analyzer. isqlw can be used with (when valid login information, input and output files are specified) or without a user interface (if input and output files are not specified). The isqlw utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

itwiz - itwiz allows the Index Tuning Wizard to be executed from a command prompt. Index tuning using an itwiz is similar to tuning via Index Tuning Wizard with a user interface. The itwiz utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

logread - logread is used for configuring and starting a Log Reader Agent. All transactions (marked for replication) move from the transaction log on the Publisher to the distribution database. The logread utility is installed to the \Program Files\Microsoft SQLServer\80\Com directory by default.

makepipe - A diagnostic utility used for the network Named Pipe services "checks-if-it-is-working" integrity testing. The makepipe utility should be launched at the database server console and it expects a connection from readpipe, started at problem SQL-client console. After makepipe is started, the database server waits for a client to connect. In other words, makepipe is used in conjunction with the readpipe utility. This utility is no longer installed by SQL Server 2000 Setup. If you need to run it - please do this manually from the \x86\Binn directory on the SQL Server 2000 compact disc, or manually copy it to any location.

odbccmpt - A migration assistance utility that enables or disables the 2.65 SQL Server ODBC driver support. Odbccmpt should be used ONLY (!!!) for applications having problems in porting to Microsoft SQL Server 2000 (and 3.7 SQL Server ODBC driver). The odbccmpt utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

odbcping - A diagnostic utility that every DBA (in case ODBC related connection problems should appear) should use for testing ODBC data source integrity and the ability of successful connection between SQL-client and database server. This utility is no longer installed by SQL Server 2000 Setup. If you need to run it - please do this manually from the \x86\Binn directory on the SQL Server 2000 compact disc, or manually copy it to any location.

osql - A utility for interactive Transact-SQL scripts and stored procedures execution. It uses ODBC libraries for communicating with the database server. Osql can be started directly from the operating system command prompt and uses a standard output device (monitor, by default) for displaying results. The osql utility is installed to the \Program Files\Microsoft SQLServer\80\Tools\Binn directory by default.

Part one of this two part series has introduced tools hidden in every SQL Server 2000 installation, with the primary focus being an introduction to the SQL Server command line utilities. The next installment will continue our examination of these utilities.

» See All Articles by Columnist Alexzander Nepomnjashiy



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM