Howdy Dan, Sunday, March 9, 2003, 8:31:54 PM, dan martin wrote:
> ... I am wondering if it would make more sense to migrate to an open > source db: mySQL or postgresql. I am running win2k with cf5 and would > like to keep the db on the same server. One thing you didn't mention was your environment - will this be only for development, or for production, or both? If production, will this be on your own server(s), or third-party shared hosting? > Does anyone have experience or comparison information between the 3 > choices running on win2k? How much work is it to port access to mysql > or postgresql? For sql2k the upgrade tool does most of the work for > you. Are there obvious benefits performance or feature wise between > the choices? I'm a newbie myself to MySQL (v. 3.23.54 on Win2k) and am still learning my way around. With MyODBC I've found it's pretty easy to get Access to talk to MySQL, so it should be fairly easy to import your Access db to MySQL (I've pulled MySQL tables into Access, just as a test, but haven't gone the other way around...yet). There are several free front-end tools that I've been playing with that you might find worth checking out. They have varying capacities for export/import: - DBTools/DBManager: http://www.dbtools.com.br/EN/ - MySQL Control Center: http://www.mysql.com/products/mysqlcc/index.html - MySQL-Front: http://mysqlfront.venturemedia.de/index.php?act=ST&f=1&t=2&s=1a695d95d6c1514352366168370a801d (this tool is no longer being developed, but it still works well and can be downloaded at this URL) - SQLYog: http://www.webyog.com/sqlyog/index.html - eSQLManager: http://www.errorsoft.nl/index.jsp ...and here's a commercial tool (I haven't used this, but you might be interested anyway): - Navicat: http://www.mysqlstudio.com/index.php MySQL should be releasing version 4.1 real soon (no hard date announced on this yet, but what I've picked up from the MySql list, it would appear to be coming very soon). Version 4.1 will support sub-selects. Here's an article covering it: http://www.mysql.com/press/release_2003_05.html Might be worth the wait. Just for grins, here's a few more MySQL related links that may be of interest to you: - PHP & MySQL Tips and Tutorials: http://www.sitepoint.com/subcat/98 - MySQL articles on Database Journal: http://www.databasejournal.com/features/mysql/ - Oh, my--MySQL!: http://builder.com.com/article.jhtml?id=u00320020523dol01.htm&fromtm=e602 - MySQL articles: http://www.kitebird.com/articles/ - Migrating from Microsoft Access to MySQL: http://www.kitebird.com/articles/access-migrate.html - A collection of Articles about MySQL: http://www.mysql.com/articles/index.html - and of course, the big kahuna, MySQL Reference Manual: http://www.mysql.com/doc/en/index.html A couple more comparisons: - PostgreSQL vs. MySQL: http://www.webtechniques.com/archives/2001/09/jepson/ - MySQL vs. PostgreSQL: http://builder.com.com/article.jhtml?id=u00320020624gcn01.htm&fromtm=e602 Hope you get something useful out of all the above. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
