Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011
    Posts
    5

    Unanswered: copy database table from one server to another

    Hi,

    I am new to this forum and new to sybase.
    I have a database table on one server, and I have a need to create another "identical" database table on another server. Copy part of the data from the first server to the second server.
    I have searched and found option of using bcp.. however, I am not sure how I can create an identical database table. I meant I have to create the rules, keys and structures etc.

    Any suggestions on how I can go about doing it?

    thanks

  2. #2
    Join Date
    Mar 2008
    Posts
    96
    you can use ddlgen utility to get the ddls for the table. This will give the tsql statement to create the table and related constraints. Take the BCP out at source,create the table at target using tsql statement you made using ddlgen utility, then bcp in the data at target.


    refer the link SyBooks Online for more information

  3. #3
    Join Date
    Jun 2011
    Posts
    5

    ddlgen

    Thanks, but my system does not have ddlgen, "find" couldn't find it..we are running 12_5, if it matters.

  4. #4
    Join Date
    Sep 2008
    Posts
    40
    ddlgen will be found in the folowing path..

    $SYBASE/ASEP/bin (%SYBASE%\ASEP\bin in Windows).








  5. #5
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    ASE-12_5/bin/ddlgen

Posting Permissions

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