OnWorks favicon

datacopy - Online in the Cloud

Run datacopy in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command datacopy that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator



datacopy - move table data between two servers


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


datacopy is a utility distributed with FreeTDS. datacopy will move table data from one
server to another without the need for intermediate files. datacopy is much faster and
more efficient than is freebcp out/in.

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

datacopy can be used to migrate data between Sybase ASE and SQL Server or vice versa.


-t Truncate target table before loading data.

-a Append data to target table.

-c owner
Create the target table with the same schema as the source table. datacopy will
submit a 'create table' command on the target server/database 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.

-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 will prompt the user for the

-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 will prompt the user for the information.

Use datacopy online using onworks.net services

Free Servers & Workstations

Download Windows & Linux apps

  • 1
    A Kotlin script that nukes all build
    caches from Gradle/Android projects.
    Useful when Gradle or the IDE let you
    down. The script has been tested on
    macOS, but ...
    Download deep-clean
  • 2
    Eclipse Checkstyle Plug-in
    Eclipse Checkstyle Plug-in
    The Eclipse Checkstyle plug-in
    integrates the Checkstyle Java code
    auditor into the Eclipse IDE. The
    plug-in provides real-time feedback to
    the user about viol...
    Download Eclipse Checkstyle Plug-in
  • 3
    AstrOrz Player is a free media player
    software, part based on WMP and VLC. The
    player is in a minimalist style, with
    more than ten theme colors, and can also
    Download AstrOrzPlayer
  • 4
    Kodi Movistar+ TV es un ADDON para XBMC/
    Kodi que permite disponer de un
    decodificador de los servicios IPTV de
    Movistar integrado en uno de los
    mediacenters ma...
    Download movistartv
  • 5
    Code::Blocks is a free, open-source,
    cross-platform C, C++ and Fortran IDE
    built to meet the most demanding needs
    of its users. It is designed to be very
    Download Code::Blocks
  • 6
    Amidst or Advanced Minecraft Interface
    and Data/Structure Tracking is a tool to
    display an overview of a Minecraft
    world, without actually creating it. It
    can ...
    Download Amidst
  • More »

Linux commands