Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    6

    Unanswered: Problem with defncopy

    I'm having some problems with defncopy

    when I issue the following command
    defncopy -Umyuser -Pmypass -Smysvr out btmp dbname dbo.tbl_name

    it just gives me an empty tbmp file(well.not empty)
    /* ### DEFNCOPY: END OF DEFINITION */


    I do have full select privs on syscomments and sysobjects tables.


    any ideas? or is there another way to extract the DDL for each object i need(tables, views and procs) via Unix command line(no perl on my box)

    TIA, i'm hurting here.

    bill

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Lightbulb

    Defncopy doesn't work to extract the table DDL. Only working with the stored procedures (because it reads syscomments)

    To extract the DDL of a table, use Sybase Central, PowerDesigner ... or write (or download) some existing tools (like geniddl)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •