can i import stored procedures from one database to sybaseIQ database?

[former_member214822]

Hi... I am new one to  SybaseIQ and I have a doubt on importing stored procedures from  one database to  sybaseIQ database..can any one help me ? 

Thanks & Regards

Murali Krishna

[Former Member]

Is the original stored procedure is IQ database?
You can generate DDL of stored procedure using IQ Cockpit or SCC for IQ.

THT

Yasuo Kogawa

[former_member214822]

Thanks  for your rewply

[markmumy]

If you are migrating from something other than SAP IQ, I would use something like PowerDesigner for that.  This tool is used quite extensively for data modeling (among other things).  While it won't convert the code from, say, Oracle PL-SQL to SAP IQ T-SQL/Watcom-SQL it will allow you to extract everything from the source, port what it can (like datatypes) and leave the SQL code for you to port.  Depending on the source system, there may not be that much effort involved in the actual port either.  In my experience, quite a lot of porting from DB2, MS SQL, Oracle, etc is easy as most code is in ANSI SQL.  For this things that are extensions (like Oracle DECODE) we have guides that can help in the translation.

Mark