php - Problems migrating MS Access to MySQL Database -
we developed php/mysql programme works fine when test info entered through programme when migrated actual info ms access mysql using odbc there problems.
the mysql , access databases have quite different schemas. looking @ migrated info in phpmyadmin, appears info imported (all info there) when seek view info through program, info retrieval selective (some info retrieved , not). example, if select “company” on page dropdown, correctly displays company info if navigate page supposed display products associated subdivision , select “subdivision” dropdown, either doesn’t display info or displays 1 product though there several.
how troubleshoot problem?
originally looking protocol or suggestions on how troubleshoot issue. decided more manageable @ little section of info only. discovered info needed cleaned. there text strings in fields should not allow them , unusual characters in fields. there issue blank spaces on data. prepare this, had strip blanks , add together them in again. 1 time info cleaned, programme working should.
php mysql ms-access odbc database-migration
No comments:
Post a Comment