I have done this as well and found that trying to maintain A copy for the 4 major DB platforms was a nightmare. So with Slight tweaking, I was able to maintain 1 copy of the application And provide scripts for each DB platform (Other than Oracle).
I provided scripts for MS-SQL, MySQL and provided the Access DB. Some things for each one are: MS-Access and MS-SQL can have Default Date fields however, MySQL wont. All 3 of those platforms can have IDENTIFY (type) Fields that auto-increment. So if you have basic queries that Are not DB dependent, you can do it. Just remember when adding date fields, you add it via query And not rely on the DB to do it by default. -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 4:33 PM To: CF-Talk Subject: Re: Building Applications for multiple DB's Well I have a different take on this...but it really all comes down to what kind of SQL you've got. Obviously a switch from Oracle to MS SQL Server will have some re-writes involved (PL-SQL to T-SQL), but going from Access to MS SQL Server you should just be able to point at the new DB and fire it up. As I said...it does depend on what DB features you are using....so if you have a complex DB wuith loads of SPs etc...the yes...it could be tough....if it's a simple DB then the swicth could be very painless Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:202308 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
