SYBASE使用辅助工具，用defncopy导出表结构

最新推荐文章于 2015-11-14 15:21:00 发布

原创最新推荐文章于 2015-11-14 15:21:00 发布 · 2.5k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sybase #工具 #database #file #triggers

#security

收录于

本文介绍了defncopy工具的功能及使用方法。此工具用于在数据库和操作系统文件间复制指定视图、规则、默认值、触发器、过程或报告的定义。文章详细列举了各种命令行选项，帮助用户灵活配置复制任务。

defncopy:

Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database.

Usage: defncopy
    [-v]
    [-X]
    [-a <display_charset>]
    [-I <interfaces_file>]
    [-J [<client_charset>]]
    [-K <keytab_file>]
    [-P <password>]
    [-R <remote_server_principal>]
    [-S [<server_name>]]
    [-U <user_name>]
    [-V <security_options>]
    [-Z <security_mechanism>]
    [-z <language>]
    { in <file_name> <database_name> |
      out <file_name> <database_name> [<owner>.]<object_name>
          [[<owner>.]<object_name>...] }