.\"Text automatically generated by txt2man
.TH datacopy 1 "13 November 2011" "doc" "FreeTDS Utilities"
.SH NAME
\fBdatacopy \fP- move table data between two servers
.SH SYNOPSIS
.nf
.fam C
\fBdatacopy\fP { \fB-t\fP | \fB-a\fP | \fB-c\fP \fIowner\fP } [\fB-b\fP \fIbatchsize\fP] [\fB-p\fP \fIpacketsize\fP] [\fB-v\fP] [\fB-d\fP]
         [\fB-S\fP \fIserver/username/password/database/table_or_view\fP]
         [\fB-D\fP \fIserver/username/password/database/table\fP]

.fam T
.fi
.fam T
.fi
.SH DESCRIPTION
\fBdatacopy\fP is a utility distributed with FreeTDS. 
\fBdatacopy\fP will move table data from one server to another without
the need for intermediate files. \fBdatacopy\fP is much faster
and more efficient than is freebcp out/in.
.PP
\fBdatacopy\fP makes use of the db-lib bcp API built into FreeTDS. This 
API is also available to application developers.
.PP
\fBdatacopy\fP can be used to migrate data between Sybase ASE and SQL Server
or vice versa.
.SH OPTIONS
.TP
.B
\fB-t\fP
Truncate target table before loading data.
.TP
.B
\fB-a\fP
Append data to target table.
.TP
.B
\fB-c\fP \fIowner\fP
Create the target table with the same schema as the source
table. \fBdatacopy\fP will submit a 'create table' command on 
the target server/database using the specified \fIowner\fP in 
.RS
.TP
.B
the command, e.g. CREATE TABLE \fIowner\fP\.table (\.\.\.).
.RE
.TP
.B
\fB-b\fP \fIbatchsize\fP
The number of rows per batch of data copied. 
Each batch of data is effectively 'committed'
to the database. The default is 1000. 
.TP
.B
\fB-p\fP \fIpacketsize\fP
The number of bytes, per network packet, sent to 
and from the servers. Increased packet size can enhance 
performance.
.TP
.B
\fB-v\fP
Produce verbose output, including diagnostic timings.
.TP
.B
\fB-d\fP
Produce freetds TDSDUMP output. (Serious debug only!)
.TP
.B
\fB-S\fP \fIserver/username/password/database/table_or_view\fP
The connection information for the source server
and the location/name of the table (or view) to be copied.
If not specified, \fBdatacopy\fP will prompt the 
user for the information.
.TP
.B
\fB-D\fP \fIserver/username/password/database/table\fP
The connection information for the destination server
and the location/name of the target table.
If not specified, \fBdatacopy\fP will prompt the 
user for the information.
.SH SEE ALSO
\fBfreebcp\fP(1), \fBdefncopy\fP(1), \fBbsqldb\fP(1), \fBtsql\fP(1), \fIFreeTDS User Guide\fP.
.SH HISTORY
\fBdatacopy\fP first appeared in FreeTDS 0.64.
.SH AUTHORS
The \fBdatacopy\fP utility was written by Bill Thompson
(thompbil@exchange.uk.ml.com).