Kbase P66114: Is there a tool to convert SQL Server stored procedures into Progress stored procedures?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Is there a tool to convert SQL Server stored procedures into Progress stored procedures?
FACT(s) (Environment):
MS SQL
FIX:
Unfortunately there is no tool to convert stored procedures. SQL Server stored procedures use a combination of a Microsoft script and SQL, but Progress ones are written in Java. You have to re-write your procedures manually. For more information, please refer to "SQL-92 Guide and Reference", chapter 5 "Writing stored procedures and triggers". You may also like to look at solution P20617 for a sample stored procedure.