datacopy (1) - Linux Man Pages
datacopy: move table data between two servers
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 ]
DESCRIPTIONis 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.
- Truncate target table before loading data.
- Append data to target table.
- -c owner
- 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 (...).
- -b batchsize
- The number of rows per batch of data copied. Each batch of data is effectively 'committed' to the database. The default is 1000.
- -p packetsize
- The number of bytes, per network packet, sent to and from the servers. Increased packet size can enhance performance.
- -T textsize
- Specify size of TEXT/IMAGE column from network.
- Produce verbose output, including diagnostic timings.
- Produce freetds TDSDUMP output. (Serious debug only!)
- -S server/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.
- -D server/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.
- Keep identity values.