DATACOPY(1)

DATACOPY(1) 💅 move table data between two servers 💅

🌸 NAME 🌸

datacopy — move table data between two servers.

🦋 SYNOPSIS 🦋

datacopy [-vdE] {-t | -a | -c owner} [-b batchsize] [-p packetsize]
         [-S server/username/password/database/table_or_view]
         [-D server/username/password/database/table] [-T textsize]

✨ DESCRIPTION ✨

okay so bestie, datacopy is a utility distributed with FreeTDS. It moves table data from one server to another without the need for intermediate files — no temp-file middleman, we love that for us 💖.

It is much faster and more efficient than is freebcp out/in. No cap.

datacopy makes use of the db-lib bcp API built into FreeTDS. This API is also available to application developers — slay for them ✨.

datacopy can be used to migrate data between Sybase ASE and SQL Server or vice versa. Iconic cross-server behavior 💅.

🎀 OPTIONS 🎀

• -t — truncate the target table before loading data. (Target gets cleared first, bestie.)
• -a — append data to the target table.
• -c owner — create the target table with the same schema as the source table. datacopy submits 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.
• -v — produce verbose output, including diagnostic timings.
• -d — 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, datacopy 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, datacopy prompts the user for the information.
• -E — keep identity values.

Heads-up for -d: the original says “Serious debug only!” and we are respecting that energy 💀.

👑 SEE ALSO 👑

freebcp(1), defncopy(1), bsqldb(1), tsql(1), FreeTDS User Guide.

🌈 HISTORY 🌈

datacopy first appeared in FreeTDS 0.64. A little vintage moment 🎀.

🫶 AUTHORS 🫶

The datacopy utility was written by Bill Thompson <thompbil@exchange.uk.ml.com>. Thank you Bill, king behavior 👑.

---

This page’s very cute sign-off: FreeTDS 1.5.20, dated March 25, 2015. Bye bestie, go move that table data responsibly 🌸✨