Re: Help on writing multi-DBMS platform apps.

munsoor_negyal@my-dejanews.com wrote in message <6r90dp$300$1@nnrp1.dejanews.com>... >I work for a company that writes add-ons/modifications to a package which >includes Sales Order Processing Purchase Order Processing Manufacturing >Financials > >It contains > 500 tables. It can be on a number of platforms (UNIX or NT) >MS-SQLServer, Informix-SE, Informix Online, Oracle, or C-ISAM files. > >Unfortunately , each of these platforms have slightly different table >schemas. e.g. Some use 8 character dates instead of DateTime variables, the >table names may be different, some fields may even have slightly different >names (rare). Our company sells a software tool that will allow you to design one database model, and automatically create schemas for MS-SQL, Informix, Oracle, Ingres, InterBase, MicroSQL, MS-Access, SQLBase and ANSI. It also creates Java source code that you can use to create a database using JDBC! The data type mapping is fully configuarble, entity integrity, referential integrity and in v1.06 (to be released this month) we also include domain integrity. With Database Design Studio (DDS), you can concentrate on your design, and let DDS take care of the schemas. It also includes an ODBC SQL Console, offline Datastore and a whole lot of other features all for less than USD$40!! Try a 14 day demo copy from www.ChilliSource.com today. Lee ---------------------------------------------------------- lee@ChilliSource.com www.ChilliSource.com -- The Home of Database Design Studio