Extract SP and DDL Scripts in sybase Server

Question

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

score 1 · Answer 1 · answered Feb 26 '13 at 05:30

1

You can use sp_helptext to show the DDL.

answered Feb 26 '13 at 05:30

Iswanto San

18,263
13
58
79

Yeah tried..But formatting is not proper with sp_helptext. Also any command available to extract DDL script ? – antosnowin Feb 26 '13 at 11:07

score 1 · Accepted Answer · answered Feb 26 '13 at 16:44

1

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.

answered Feb 26 '13 at 16:44

Mike Gardner

6,611
5
24
34

Thanks Michael..But do u have any easy way like in sql server..i m new to sybase.. – antosnowin Feb 27 '13 at 09:30
*ddlgen* **is** the easy way to extract database objects. With minimal options, you can extract everything from the database. – Mike Gardner Feb 27 '13 at 13:50

Extract SP and DDL Scripts in sybase Server

2 Answers2

Linked