Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help 
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 simi-
     lar 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 out-
     put, and writes errors to standard error. The -i, -o, and -e options  over-
     ride 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 version
     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.1.5.436		 April 26, 2012 	       DEFNCOPY(FreeTDS)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=defncopy&sektion=1&manpath=FreeBSD+Ports+15.1.quarterly>

home | help