> then remember that MSSQL Express is also FREE limited to 4GB in size.
if you definitely want to end up with MySQL then it would be easier to use the built in wizard to upsize from MSAccess to MSSQL then (if you still want to) ... convert from MSSQL to MySQL i would bother trying to use the MySQL Migration Tool Kit. ive never had much luck with this. I've converted many DBs from MS to My. So many that i bought some third party software to do it for me. takes about 30 seconds. Let me know if i can help out. zac Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied please visit: http://www.allied-facilities.com -----Original Message----- From: Russ Michaels [mailto:[email protected]] Sent: 20 April 2011 11:20 To: cf-talk Subject: Re: MySQL Conversion You would probably find it easier to upgrade to MSSQL, which is better anyway in so many ways than MySQL esp if you are on windows (speed, performance, reliability, scheduled backups, automated maintenance, no table corrupting issues, no horrid SQL dumps to name a few). Presumably if your using Access you must be on a windows host, so MSSQL is probably available to you. If you are choosing MySQL only because it is free, as many do, then remember that MSSQL Express is also FREE. You have an upgrade tool built in to MSACCESS, and Microsoft also provide free migration tools as well. just something to consider. On Wed, Apr 20, 2011 at 7:22 AM, Azadi Saryev <[email protected]>wrote: > > how are you migrating your db? > > mysql used to have a migration toolkit as part of mysql gui tools bundle > which handled access->mysql migration very well. > the gui tools have now been replaced by mysql workbench, but you can > still download them from mysql website. > gui tools: http://dev.mysql.com/downloads/gui-tools/5.0.html > workbench: http://dev.mysql.com/downloads/workbench/5.2.html > > mysql equivalent of access's autonumber type is an Integer column with > auto_increment attribute. > http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html (bottom of > page for auto_increment attr info) > you can also set/change the next auto_increment value to use on mysql > column: ALTER TABLE t2 AUTO_INCREMENT = value (from > http://dev.mysql.com/doc/refman/5.5/en/alter-table.html) > > all this and much much more is covered in mysql reference manual on > mysql website: http://dev.mysql.com/doc/ > > another point to keep in mind: if you cfqueries used any access-specific > syntax you will have to re-write them to use proper sql to work with > mysql db. > > Azadi > > On 20/04/2011 13:46 , Scott Williams wrote: > > Oy -- I shouldn't have started this one until the weekend. > > > > I'm converting from MS Access to MySQL on one of my ColdFusion sites, and > having problems converting my Autonumbered Access tables to MySQL format. > They just won't import at all. If I remove the primary key and change the > format to Integer instead of Autonumber, the tables import. > > > > The real problem is when I try to add data to these tables later. It will > take one additional record (numbering it 0), then won't take anymore because > then there would be two 0s. > > > > How can I get a MySQL table to autonumber like Access? > > > > Scott > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
