EnglishFrenchSpanish

Ad


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

PROGRAM:

NAME


defncopy - extract procedures and views from a Microsoft server.

SYNOPSIS


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

DESCRIPTION


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.

OBJECTS


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

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

OPTIONS


-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
database.

-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.

NOTES


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.

EXIT STATUS


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.

HISTORY


defncopy first appeared in FreeTDS 0.63.

AUTHORS


The defncopy utility was written by James K. Lowden <[email protected]>

Use defncopy online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    SAGA GIS
    SAGA GIS
    SAGA - System for Automated
    Geoscientific Analyses - is a Geographic
    Information System (GIS) software with
    immense capabilities for geodata
    processing and ana...
    Download SAGA GIS
  • 2
    Toolbox for Java/JTOpen
    Toolbox for Java/JTOpen
    The IBM Toolbox for Java / JTOpen is a
    library of Java classes supporting the
    client/server and internet programming
    models to a system running OS/400,
    i5/OS, o...
    Download Toolbox for Java/JTOpen
  • 3
    D3.js
    D3.js
    D3.js (or D3 for Data-Driven Documents)
    is a JavaScript library that allows you
    to produce dynamic, interactive data
    visualizations in web browsers. With D3
    you...
    Download D3.js
  • 4
    Shadowsocks
    Shadowsocks
    A fast tunnel proxy that helps you
    bypass firewalls This is an application
    that can also be fetched from
    https://sourceforge.net/projects/shadowsocksgui/.
    It ha...
    Download Shadowsocks
  • 5
    GLPI Themes
    GLPI Themes
    Download release at
    https://github.com/stdonato/glpi-modifications/
    Color themes for GLPI 0.84 and 0.85 New
    Modifications for GLPI This is an
    application that c...
    Download GLPI Themes
  • 6
    SMPlayer
    SMPlayer
    SMPlayer is a free media player for
    Windows and Linux with built-in codecs
    that can also play YouTube videos. One
    of the most interesting features of
    SMPlayer:...
    Download SMPlayer
  • More »

Linux commands

Ad