Hi All,

I am just a newbie to sybase.
Just like Generate Scripts in MS SQL 2005 , Is there any way to extract all SPs,Triggers into output file from sysbase at one shot.
I am using Embarcadero Rapid SQL V7.6.4

Please help me out.....!!!

drop proc generateScripts

go

create proc generateScripts

as


declare @name varchar(255)

declare scriptCursor cursor

for

select name

from sysobjects

where type in ('p', 'tr')


open scriptCursor


fetch scriptCursor into @name

while @@sqlstatus = 0

begin

exec sp_showtext @name

fetch scriptCursor into @name

end


Close scriptCursor

deallocate cursor scriptCursor

If you want to generate the drop statements too

substitute
' exec sp_helptext @name, 2048, 1, "showsql, ddlgen" '
for
' exec sp_showtext @name '

use the ddlgen command line utility

Thank you guys for your kind reply.
Actually i used DbArtisan to extract all SPs into ouput (.sql) file
But now my requirement is that i need to get each and every SPs & triggers into each sql output file.

ie., I have 2254 sps so i need to generate 2254 output (.sql) files.

Is there any way to do so ? Please do help me...

Kind Regards
Deva.