Brainstorming database solutions.
– Use Specify and jettison some data that won’t fit. This wouldn’t go over well.
– Use Access and deal with not having the data schema or the Specify software (which seems like it can work fairly well).
– Use MySQL and build a frontend in PHP that mimics Q&A, including the ability to rearrange fields, sort things easily, and add new fields when needed.
– Use MySQL and steal the schema from Specify, and build a frontend in PHP.
– Use MySQL and steal the schema from Specify, and use Access as a frontend.
– Use Specify and add the columns to the tables that need to be added with Access (I think this can be done), use Specify for the web interface and Access for on-site.
– Keep bugging the Specify team to tell me how the program knows when it needs to display new tables and hope they eventually tell me (see a couple posts back).
– Waste a lot of time figuring it out on my own.
Why does it seem like the last option would be the best?
LATER:
Links that need to be made into a tutorial.
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
http://www.ucl.ac.uk/is/mysql/access/
http://mobiledeveloper.wordpress.com/2007/01/31/data-import-export-with-sql-server-express-using-dts-wizard/
http://dev.mysql.com/downloads/connector/odbc/5.1.html
http://www.ucl.ac.uk/is/mysql/odbc/
http://www.aspnetcafe.com/post/2007/12/HOWTO-Get-Complete-SQL-dump-of-SQL-Express-2005-Database.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
I use convert db to migrate the database, there are many tools available on google, i use convert db for such aim.
Find Here : http://www.convert-db.com