What's New

• SQL Server 2005 schema loader
• Minor template bug fixes

>> Buy It
>> Download It!

New Features:
• Sybase SQL Anywhere schema loader
• Foreign Keys for MySQL InnoDb tables
• Minor RapTier UI and template improvements

Bug Fixes:
• Sysproperties error loading MS SQL 7.0 databases
• GenerateMSSQLIdentity replaced by GenerateSQLIdentity in the VB.NET template
• Reloading of modified auto-increment and read-only fields

• ASP.NET UI generation
• Extended DB model (indexes, defaults, system objects, descriptions etc.)
• MS SQL, Oracle, and MySQL native loaders
• Improved FoxPro, Sybase ASE, and DB2 loaders
• @@IDENTITY support for MS Access and MySQL
• MS Access linked tables
• Wrapping of existing SQL Server and Sybase ASE stored procedures [Enterprise]
• DB documentation generator (generation of complete database documentation in HTML format) [Enterprise]
• Mass renaming of DB elements [Enterprise]
• Updateable views [Enterprise]

• Selection of database objects
• Improved DataTable mapping (100-400% speed improvement)
• DB model refreshing
• VS.NET 2003 support
• Borland C# Builder support
• Command line support
• Copyright text customization
• User interface enhancements

• Generation of WinForm UI
• Data paging
• Support of System.Data.DataTable objects
• Generation of Oracle stored procedures
• GetBy<ForeignKeyColumnName> and DeleteBy<ForeignKeyColumnName> methods support nullable columns
• Support of "Oracle Provider for OLE DB"
• "ReadOnly" property for column objects
• "DisplayName" property for column objects
• Selection of the target DB engine
• Extended documentation and tutorial
• Template recompilation without restarting RapTier
• Improved MySQL support
• Extended comments
• Generated fields and parameters have the following format _field_name instead of _fIELD_NAME
• Generation of connection strings for non-OLE DB .NET Data Providers (SqlClient, OracleClient, MySQL ByteFx)
• Static files are not rewritten if they were changed after the previous generation
• Other minor GUI and template improvements

• Support of DB schemas that use VB.NET and C# keywords as table or column names

• MySQL Support
• Fixed the "two master one detail" bug

• Support of multi-schema databases
• Improved SQL code generation:
  RapTier 1.1: "[TableName]"
  RapTier 1.2: "[Schema].[TableName]" or "Schema.TableName"
• Added warning and info messages that provide more detailed information about the results of code generation
• Generation of the protected "Database" property for all TableName_Base classes
• A few user interface enhancements
• The correct recognition of the variable length data types (VARCHAR, VARNCHAR, etc) for any OleDB data provider
• Generation of valid SQL syntax for Oracle databases
• Other minor UI and template bug fixes

• Microsoft SQL IDENTITY support
• Generation of "GetByForeignKey" and "DeleteByForeignKey" methods