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

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

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

ddlgen will be found in the folowing path..

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

ASE-12_5/bin/ddlgen