Unanswered: copy database table from one server to another
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.
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.