Tiny DDL scripts for Sybase ASE (import/export procedures, tables, triggers, views).

Script for export DDL from Sybase database to text files.
Format:

$ export.sh [user] [server] [database name]

Usage:

$ export.sh admin 10.1.100.500:9090 accounts

Script for creating structures in the database.
Format:

$ import.sh [user] [server] [*source database name] [target database name]

Usage:

$ import.sh admin 10.1.100.500:9090 accounts accounts

*Source database name = folder name with already generated ddl.

select type,count(*) 
   from sysobjects 
   where type in ('U','RI','P','TR','V')
         and name not like 'sys%' 
         and name not like 'rs_%'
group by type