hit counter

Timeline

My development logbook

A Useful Sybase Tool

defncopy is possibly the best way to retrieve a script of any Sybase database objects if you do not have access to a decent database development tools such as Aqua Data Studio

This utility comes with Sybase distribution. Here is its usage:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
$ defncopy
 
defncopy Syntax Error
Usage: defncopy
    [-v]
    [-W]
    [-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>...] }