Free stored procedure migration software for windows

Stored Procedure Tool for SQL Server. Create Stored Procedures for your database. Select between default SPs, Custom SPs and Template SPs. Include default SPs for SELECT KEY, SELECT FROM, INSERT SINGLE RECORD, DELETE KEY, UPDATE KEY and UPSERT KEY.
Build your own Stored Procedure and templates. Templates use Errorhandling, Debuginfo and comment options. Live update possible for getting latest templates. The tool is freeware and still under developement. Any ideas, suggestions or comments are welcome.

Stored Procedure Class Wizard (SPCW) is a useful development tool that allows you to generate class files (.cpp and .h) derived from MFC?s CRecordset for stored procedures. Currently SPCW supports Microsoft SQL Server (6.5 and above), Sybase SQL Server (10.0 and above), Sybase SQL Anywhere (5.5 and above), and Adaptive Server Anywhere (6.0 and above) and can be extended to any database.
Note that running SPCW against MS SQL Server or Sybase SQL Server
production databases is NOT recommended.
Following are the steps for generating class files:
Step 1:
=======
Choose from the menu.
Step 2:
=======
Select the procedure name for which you want to generate class files.
Microsoft SQL Server and Sybase SQL Server specific:
For procedures that return result set columns, choose
from the menu before generating the class files.
Step 3:
=======
Choose from the menu to generate .cpp and .h
recordset files.
Whenever you add/modify a procedure, choose from the
menu and then repeat step 3 (steps 2 & 3 in the case of MS SQL Server
and Sybase SQL Server).
To connect to another data source, first disconnect the current connection
and then connect.
Add the following lines to StdAfx.h:
#include // MFC database classes
#define ODBC_DSN_INFO _T("ODBC;DSN= ")

There is already a utility that comes with VB 5.0 to add a procedure to your code. The problem I have with it is that you always have to type in generic error handling code with each procedure. I have written an add-in that you can add to VB 5.0 that will add a procedure to your code (much like the one already in VB 5.0, but it will also insert some error handling code for you.)

SwisSQL - Sybase to Oracle Edition is an automated migration tool to convert stored procedures implemented in Sybase Adaptive Server Transact SQL into equivalent PL/ SQL code.
It automates more than 90% of the Sybase Transact SQL code conversion into Oracle PL/SQL with very minimal manual intervention.
SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time.
Main features:
- Migration of Transact SQL procedures, functions, triggers, cursors, tables and views into Oracle PL/SQL.
- Support for conversion of Transact SQL In-Built Functions, SQL queries & all In-Built data types (including user-defined types).
- Support for conversion of both Microsoft SQL Server and
- Sybase Adaptive Server T-SQL Statements.
- Support for conversion of all Transaction features.
- Support for Cursor Declaration, OPEN, FETCH, CLOSE and DEALLOCATE Statements Conversion.
- Support for conversion of Temporary table feature into PL/SQL.
- Support for conversion of most of the @@ Global variables into equivalent PL/SQL implementation.
- Support for Result-Set Processing conversion from Transact SQL to PL/SQL.
- Support for T-SQL Label, Assignment, Control and Conditional Statements conversion.
- Generation of formatted, readable PL/SQL code with good comments.
- A user friendly Graphical user interface with support for
- One click conversion of Sybase transact SQL into PL/SQL.
- Fetching TransactSQL model from database directly and converting. Also supports conversion of source files from local directory.
- Project driven organization of converted code to ease maintenance.

SwisSQL - SQL Server to Oracle Migration Tool - automated migration tool to convert SQL Server Transact SQL to Oracle PL/SQL SwisSQL - SQL Server to Oracle Edition is an Automated Migration utility that allows you to convert stored procedures implemented in Microsoft SQL Server Transact SQL into equivalent Oracle PL/SQL code.
SwisSQL - SQL Server to Oracle Migration Tool automates more than 90% of the Transact SQL code conversion into PL/SQL with very minimal manual intervention.
SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time.
Main features:
- Migration of SQL Server Transact SQL procedures, functions, triggers, cursors, tables and views into PL/SQL.
- Supports conversion of Transact SQL In-Built Functions, SQL queries & all In-Built data types (including user-defined types).
- Supports conversion of all Transaction features.
- Supports conversion of Temporary table feature into PL/SQL.
- Supports conversion of most of the @@ Global variables into equivalent PL/SQL implementation.
- Support for Result-Set Processing conversion from Transact SQL to PL/SQL.
- Generates formatted, readable PL/SQL code with very good comments.
- Provides an ease to use Graphical user interface with support for single click driven migration.
- The tool supports two modes of conversion: (i). It could fetch Transact SQL model directly from database and convert them (ii) Supports conversion of Transact SQL source files loaded from local directory.
System requirements:
- 128 MB RAM
- PIII 800 MHz
- 50 MB hard disk space