> I've got several sites using Access databases and the idea of moving > them all into mySQL is appealing.
> Would it be fairly straightforward to setup mySQL and then import them? > Some of the sites use Autonumber fields... would that be a problem or > does it have an equivalent? > All pretty easy.... You need to check the indexes once you've imported your tables and data, but both mySQLFront and SQLyog have ODBC import routines, that allow you to import either from an ODBC DSN or a file database. Autonumbers are called auto_increment in mysql, but the ODBC import thingy picks all that up and converts it appropriately. You may need to set INT length after the import, as Access has no length on Numeric fields, but most other DBs do. Errmmm.. can't think of anything else like..... Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
