Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   44335 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

DEFNCOPY(FreeTDS)	   FreeTDS Reference Manual	     DEFNCOPY(FreeTDS)

NAME
     defncopy — extract procedures and views from a Microsoft server.

SYNOPSIS
     defncopy [-v] [-U username] [-P password] [-S server] [-D database]
	      [-i input_file] [-o output_file] [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.	 owner is optional if you or the data‐
     base 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, -o, and -e options
     override these defaults.

     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
     ⟨jklowden@schemamania.org.⟩

BUGS
     Works only with Microsoft servers and ancient Sybase servers.  Does not
     create primary keys.  Many options are defined by Sybase that this ver‐
     sion does not implement. Feel free to correct this situation.  In theory,
     defncopy could apply/produce DDL for any system object, but at present
     only tables, procedures and views are supported, and only for extraction.

FreeTDS dev.0.99.479		April 26, 2012		  FreeTDS dev.0.99.479

Vote for polarhome