OnWorks favicon

defncopy - Online in the Cloud

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

This is the command defncopy 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



defncopy - extract procedures and views from a Microsoft server.


defncopy [-U username] [-P password] [-S server] [-D database]
[-i input_file] [-o output_file] [-v]
[owner.]object_name [[owner.]object_name...]


defncopy is a utility program distributed with FreeTDS. It replaces a similar program of
the same name distributed by Sybase.

defncopy reads the text of a stored procedure or view, and writes a script suitable for
recreating the procedure or view. For tables, it reads the output of sp_help and
constructs a CREATE TABLE statement, complete with CREATE INDEX, too.


owner is optional if you or the database owner is the owner of the procedure/view being

is the name of the system object you wish to extract.


-U username
database server login name.

-P password
database server password.

-S server
database server to which to connect.

-D database
database to use. Optional if the procedure/view being extracted is in your default

-i input_file
a script to apply to the database. Not currently implemented.

-o output_file
a file to hold the script, defaults to standard output.

-v Show version information and copyright notice.


defncopy is a filter; it reads from standard input, writes to standard output, and writes
errors to standard error. The -i and -o options override these, of course.

defncopy makes use of the db-lib API provided by FreeTDS. This API is of course also
available to application developers.


defncopy exits 0 on success, and >0 if the server cannot process the query.

defncopy will report any errors returned by the server, but will continue processing.


defncopy first appeared in FreeTDS 0.63.


The defncopy utility was written by James K. Lowden <jklowden@schemamania.org>

Use defncopy online using onworks.net services

Free Servers & Workstations

Download Windows & Linux apps

  • 1
    A set of Python extension modules that
    wrap the cross-platform GUI classes from
    wxWidgets.. Audience: Developers. User
    interface: X Window System (X11), Win32 ...
    Download wxPython
  • 2
    This is the Total War pack file manager
    project, starting from version 1.7. A
    short introduction into Warscape
    modding: ...
    Download packfilemanager
  • 3
    A network traffic tool for measuring
    TCP and UDP performance with metrics
    around both throughput and latency. The
    goals include maintaining an active
    iperf cod...
    Download IPerf2
  • 4
    fre:ac - free audio converter
    fre:ac - free audio converter
    fre:ac is a free audio converter and CD
    ripper for various formats and encoders.
    It features MP3, MP4/M4A, WMA, Ogg
    Vorbis, FLAC, AAC, and Bonk format
    support, ...
    Download fre:ac - free audio converter
  • 5
    Write your chatbot logic once and
    connect it to one of the available
    messaging services, including Amazon
    Alexa, Facebook Messenger, Slack,
    Telegram or even yo...
    Download BotMan
  • 6
    gerbv  a Gerber (RS-274X) viewer
    gerbv a Gerber (RS-274X) viewer
    Gerbv is an open source Gerber file
    (RS-274X only) viewer. Gerbv lets you
    load several files on top of each other,
    do measurements on the displayed image,
    etc. ...
    Download gerbv a Gerber (RS-274X) viewer
  • 7
    I/O performance Analysis Tool.
    Audience: Developers, Information
    Technology, Science/Research, System
    Administrators. User interface: Win32
    (MS Windows). Progr...
    Download Iometer
  • More »

Linux commands