Well, this *is* possible, but you cannot rely on any product-specific features if you want your DDL to be product-neutral.
I use Embarcadero's ER/Studio. It is a bit pricey, but I'm not the one paying for it. ER/Studio, as well as other products, will let you reverse engineer a schema, then push it into another database system. I like ER/Studio's use of logical and physical models. You create your model "idea" in the logical view, then you create as many physical models as you will need. For example, you are building a web-based application that should support multiple database platforms. You only need to build on logical model, then from that logical model, you build physical models for Oracle, SQL, Access, MySQL, etc. I'm sure other products can do this, but I'm just the most-familiar with ER/Studio. M!ke -----Original Message----- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 12:29 AM To: CF-Talk Subject: Re: Database modeling ide I guess I did not properly explain myself. For example I would like to be able to script a database say in SQL Server and then be able to easily export also to MySQL, PostgreSQL, and Access if this is possible. That way I don't have to manually go through and tweak here and there as needed for each database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
