Search code examples
sqlsap-ase

Extract SP and DDL Scripts in sybase Server

How do I extract DDL, Stored Procedures (SP) and other database scripts from Sybase ASE.

Solution

  • Look into the ddlgen utility included with sybase, ususally found in the Sybase Central directory, or the $SYBASE/ASEP/bin. This should be able to generate scripts to create all of the database objects including user-defined datatypes (UDD), indexes, stored procedures, etc.