Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlguru
SQLTeam CoFounder
20 Posts |
 Posted - 2000-08-09 : 00:00:00
|
| Ana writes "How can I export stored procedures from SQLServer to DB2?"Well, Ana, the short answer is "you can't". The longer answer is "you maybe, maybe could if a couple of conditions are met."Every RDBMS has its own "flavor" of SQL, so unless the stored procs in SQL Server were written in ANSI compliant SQL, you'll probably have a hard time getting them to compile. Most likely, you'll need to rewrite them in DB2's flavor of SQL.You can save stored procedure code to text files by using the "Generate SQL Scripts" feature in Enterprise Manager.good luck,Sean |
|
|
|
|
|
Exporting stored procedure code to DB2