Lattice.SPGen Stored Procedure and Code Generator 3.0
generator that supports Microsoft SQL Server, Oracle, IBM DB2 UDB, PostgreSQL
and MySQL. It processes any tables and views in the database that you select
and generate stored procedures scripts of insert, update, delete, select (single
or multiple records) as well as business entities for C# and VB.NET. The output
scripts file can be chosen as one file for all tables / views or one per table /
view based on your preference. Below is how it works:
1. Collect metadata from different datasource(Oracle, DB2, SQL Server, MySQL, PostgreSQL)
2. Build xml metadata input definition file
3. Generate stored procedures and C# or VB.NET business entity using xslt with different xsl stlysheets.
Lattice.SPGen supports the following RDBMS:
* MS SQL Server 2000 and 7, MSDE 2000.
* Oracle 8i and 9i.
* IBM DB2 UDB
* MySQL 5.0
* PostgreSQL
Below is the link to download the software:
http://www.latticesoft.com/downloads/LatticeSPGen.zip
Lattice Business Software
http://www.latticesoft.com
MySQL to MSSQL Converter is a most accurate MySQL to MSSQL Converter to convert the whole database or any of its parts. It supports different data types and attributes. MySQL to MSSQL Converter can be handled via user-friendly GUI or command line.
Advanced ETL Processor Pro extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the ‘Preview` button and see what the results of an ETL flow would look like.
SQL Compare Suite makes database development, maintenance, and hot-fixing simpler. The SQL compare engine enables MS SQL Server developers to synchronize database structures between development and production servers while preserving existing data.
DreamCoder for Oracle is a free powerful Integrated Development Environment and administration tool for Oracle Databases.
DreamCoder for Oracle is a comprehensive tool for developing and managing an Oracle database.