SQL Anywhere 11 - No reverse engineering fo triggers / SP

Other Databases - related issues
Post Reply
aschild
Posts: 20
Joined: Fri Apr 19, 2013 12:06 pm

SQL Anywhere 11 - No reverse engineering fo triggers / SP

Post by aschild » Tue Apr 23, 2013 3:23 pm

Hello,

I have just reverse engineered a SQL Anywhere 11 database, but in the resulting schema I see no triggers at all.

As for the stored procedures/functions, they are imported in the schema, bus as empty procedures (Same for SQL Anywhere 9)

Any settings which might help reverse engineering them ?

André

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: SQL Anywhere 11 - No reverse engineering fo triggers / S

Post by donose.mihai » Wed Apr 24, 2013 5:16 am

Hello Andre,

From what i'm able to see the reverse engeneering for the triggers exists in DbSchema, check it out also, probably you have more experience with Sql Anywhere then us.

SELECT s.name FROM sysobjects s INNER JOIN sysusers u ON s.uid=u.uid WHERE s.type='TR' and u.name=$SCHEMA

Please let us know if we need to change something.
Attachments
2013-04-24_081458.png
2013-04-24_081458.png (56.65 KiB) Viewed 8152 times

aschild
Posts: 20
Joined: Fri Apr 19, 2013 12:06 pm

Re: SQL Anywhere 11 - No reverse engineering fo triggers / S

Post by aschild » Wed Apr 24, 2013 2:27 pm

My error,

I did create a new DB Type SQL Anywhere, but not based on the Sybase type.
So triggers & stored procedures work ok now.

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: SQL Anywhere 11 - No reverse engineering fo triggers / S

Post by donose.mihai » Thu Apr 25, 2013 6:50 am

I'm glad that your issue has been solved.

Post Reply