JezK
Edit File: usefreetds.html
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Chapter 6. Use FreeTDS</title><link rel="stylesheet" type="text/css" href="userguide.css" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="home" href="index.html" title="FreeTDS User Guide" /><link rel="up" href="index.html" title="FreeTDS User Guide" /><link rel="prev" href="stunnel.html" title="stunnel HOWTO" /><link rel="next" href="software.html" title="Chapter 7. How to get what works with it working" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Chapter 6. Use <span class="productname">FreeTDS</span> </th></tr><tr><td width="20%" align="left"><a accesskey="p" href="stunnel.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="software.html">Next</a></td></tr></table><hr /></div><div class="chapter"><div class="titlepage"><div><div><h1 class="title"><a id="usefreetds"></a>Chapter 6. Use <span class="productname">FreeTDS</span> </h1></div></div></div><div class="toc"><p><strong>Table of Contents</strong></p><dl class="toc"><dt><span class="sect1"><a href="usefreetds.html#utilities"><span class="productname">FreeTDS</span> Utilities</a></span></dt></dl></div><div class="abstract"><p class="title"><strong>Abstract</strong></p><p><span class="productname">FreeTDS</span> includes several utilities. Some are testing tools, some demonstration projects, some intended for day-to-day use. All have man pages.</p></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="utilities"></a><span class="productname">FreeTDS</span> Utilities</h2></div></div></div><div class="variablelist"><p class="title"><strong>(listed alphabetically)</strong></p><dl class="variablelist"><dt><span class="term">bsqldb</span></dt><dd><p> A non-interactive equivalent of the <span class="symbol">isql</span> utility programs distributed by Sybase and Microsoft. Like them, <span class="command"><strong>bsqldb</strong></span> uses the command <span class="quote">“<span class="quote">go</span>”</span> on a line by itself as a separator between batches. The last batch need not be followed by <span class="quote">“<span class="quote">go</span>”</span>.</p><p><span class="command"><strong>bsqldb</strong></span> makes use of the <code class="systemitem">DB-Library</code> <acronym class="acronym">API</acronym>. Intended for production use.</p></dd><dt><span class="term">bsqlodbc</span></dt><dd><p>A non-interactive equivalent of the <span class="symbol">isql</span> utility programs distributed by Sybase and Microsoft. Like them, <span class="command"><strong>bsqlodbc</strong></span> uses the command <span class="quote">“<span class="quote">go</span>”</span> on a line by itself as a separator between batches. The last batch need not be followed by <span class="quote">“<span class="quote">go</span>”</span>. It uses the <code class="systemitem">ODBC</code> <acronym class="acronym">API</acronym>.</p><p><span class="command"><strong>bsqlodbc</strong></span> is a demonstration project, but can also aid in isolating problems. <code class="systemitem">ODBC</code> applications typically have many layers, and it can be difficult to know if a problem arises in a layer, or in the interface between layers. By executing a query in <span class="command"><strong>bsqlodbc</strong></span>, you can see if the functionality of the <code class="systemitem">ODBC</code> driver works when used as the folks who wrote the driver thought it would be used.</p></dd><dt><span class="term">datacopy</span></dt><dd><p>A tool for migrating data between Sybase ASE and Microsoft SQL Server or vice versa.</p><p><span class="command"><strong>datacopy</strong></span> will move table data from one server to another without the need for intermediate files. <span class="command"><strong>datacopy</strong></span> is much faster and more efficient than is <span class="command"><strong>freebcp</strong></span> out/in.</p><p><span class="command"><strong>datacopy</strong></span> makes use of the <code class="systemitem">DB-Library</code> bcp <acronym class="acronym">API</acronym>.</p></dd><dt><span class="term">defncopy</span></dt><dd><p>Replaces a similar program of the same name distributed by Sybase.</p><p><span class="command"><strong>defncopy</strong></span> reads the text of a stored procedure or view, and writes a script suitable for recreating the procedure or view. For tables, it reads the output of <span class="command"><strong>sp_help</strong></span> and constructs a <code class="literal">CREATE TABLE</code> statement, complete with <code class="literal">CREATE INDEX</code>, too.</p></dd><dt><span class="term">fisql</span></dt><dd><p>A complete replacement of the <span class="symbol">isql</span> utility programs distributed by Sybase and Microsoft. Like them, <span class="command"><strong>fisql</strong></span> uses the command <span class="quote">“<span class="quote">go</span>”</span> on a line by itself as a separator between batches.</p></dd><dt><span class="term">freebcp</span></dt><dd><p>Replicates the functionality of the <span class="symbol">bcp</span> utility programs distributed by Sybase and Microsoft.</p><p><span class="command"><strong>freebcp</strong></span> makes use of the <code class="systemitem">DB-Library</code> bcp <acronym class="acronym">API</acronym>.</p><p>The manual pages or online help for Sybase or Microsoft SQL Server can be referenced for more detailed information on bcp functionality.</p></dd><dt><span class="term">osql</span></dt><dd><p>A Bourne shell script that checks and reports on your configuration.</p></dd><dt><span class="term">tsql</span></dt><dd><p>A diagnostic tool that uses uses the lowest level <span class="productname">FreeTDS</span> library, <span class="symbol">libtds</span>, as a way to isolate potential bugs in the protocol implementation.</p><p><span class="command"><strong>tsql</strong></span> is <span class="emphasis"><em>not</em></span> a replacement for a complete <span class="symbol">isql</span>.</p></dd></dl></div></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="stunnel.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="software.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">stunnel HOWTO </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Chapter 7. How to get what works with it working</td></tr></table></div></body></html>