datacopy (1) Linux Manual Page
NAME
datacopy – move table data between two servers
SYNOPSIS
[-vdE ] Br o –t | –a | –c owner Br c [-b batchsize ] [-p packetsize ] [-S server/username/password/database/table_or_view ] [-D server/username/password/database/table ] [-T textsize ]
DESCRIPTION
is a utility distributed with FreeTDS. will move table data from one server to another without the need for intermediate files. is much faster and more efficient than is freebcp out/in.
makes use of the db-lib bcp API built into FreeTDS. This API is also available to application developers.
can be used to migrate data between Sybase ASE and SQL Server or vice versa.
OPTIONS
-t- Truncate target table before loading data.
-a- Append data to target table.
-cowner- Create the target table with the same schema as the source table. will submit a `CREATE’ TABLE command on the target server using the specified owner in the command, e.g. `CREATE’ TABLE owner.table (…).
-bbatchsize- The number of rows per batch of data copied. Each batch of data is effectively ‘committed’ to the database. The default is 1000.
-ppacketsize- The number of bytes, per network packet, sent to and from the servers. Increased packet size can enhance performance.
-Ttextsize- Specify size of TEXT/IMAGE column from network.
-v- Produce verbose output, including diagnostic timings.
-d- Produce freetds TDSDUMP output. (Serious debug only!)
-Sserver/username/password/database/table_or_view- The connection information for the source server and the location/name of the table (or view) to be copied. If not specified, prompts the user for the information.
-Dserver/username/password/database/table- The connection information for the destination server and the location/name of the target table. If not specified, prompts the user for the information.
-E- Keep identity values.
SEE ALSO
freebcp(1),Xrdefncopy1,Xrbsqldb1,Xrtsql1, FreeTDS User Guide.
HISTORY
first appeared in FreeTDS 0.64.
AUTHORS