FreeBSD Manual Pages
UNTITLED() LOCAL UNTITLED() 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 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, -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 con- tinue 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 the- ory, 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.1.4.434 April 26, 2012 DEFNCOPY(FreeTDS)
NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | EXIT STATUS | HISTORY | AUTHORS | BUGS
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=defncopy&sektion=1&manpath=FreeBSD+Ports+14.3.quarterly>