EnglishFrenchSpanish

Ad


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

PROGRAM:

NAME


datacopy - move table data between two servers

SYNOPSIS


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]

DESCRIPTION


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.

OPTIONS


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

Use datacopy online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    formkiq-core
    formkiq-core
    FormKiQ Core is an Open Source Document
    Management System (DMS), available to
    run as a headless software or with a
    web-based client, deployed to your
    Amazon We...
    Download formkiq-core
  • 2
    Blackfriday
    Blackfriday
    Blackfriday is a Markdown processor
    implemented in Go. It is paranoid about
    its input (so you can safely feed it
    user-supplied data), it is fast, it
    supports c...
    Download Blackfriday
  • 3
    QNAP NAS GPL Source
    QNAP NAS GPL Source
    GPL source for QNAP Turbo NAS.
    Audience: Developers. User interface:
    Web-based. Programming Language: C,
    Java. Categories:System, Storage,
    Operating System Ker...
    Download QNAP NAS GPL Source
  • 4
    Vuls
    Vuls
    Vuls is open-source, agent-less
    vulnerability scanner based on
    information from NVD, OVAL, etc. Vuls
    uses multiple vulnerability databases
    NVD, JVN, OVAL, RHSA...
    Download Vuls
  • 5
    deep-clean
    deep-clean
    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
  • 6
    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
  • 7
    AstrOrzPlayer
    AstrOrzPlayer
    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
    b...
    Download AstrOrzPlayer
  • More »

Linux commands

Ad