This topic is locked

Problems with DB

2/21/2008 4:06:16 AM
PHPRunner General questions
W
wex-alpha author

Hello everyone,
First to say this is one excellent program, that will I am sure of it save me many hours of my time.

But as always there are beginners problems included <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7621&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Let me begin in order with my problem <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7621&image=2&table=forumtopics' class='bbc_emoticon' alt=':)' />
My plan is to make a application (inventory tracking of some sort) that will be used in my campus (maybe 300 users). It will be placed on to USB memory stick.
This was my plan initially:

  • Convert my MS Access DB using PHP runner
  • Use the generated files with portablewebapp (http://www.portablewebap.com/)
  • Use the program
    But, I have run in several problems already. First problem is License. Since my project will have commercial side (even though there will be no money making) I cant use MYSQL, since it is not free.
    Portableweb application supports SQLlite which is totally free.
    My question is:
    How do I process my MS Access DB and obtain SQLite Source file? What I want to do is build a DB using that file and run my application
    Another side question (regarding MySQL):

    When I convert MS Access DB, I can manipulate it in a lot of ways, but one thing eludes me. How do I recreate a MySQL DB either on localhost or remote server? IN another words where is the .sql or .txt file that holds the DB structure?

Alexey admin 2/21/2008

MySQL is distrubuted under General Public License so it's free for both commercial and non-commercial use.

http://www.mysql.com/company/legal/licensing/
Regarding the Access to SQLLite conversion I recommend you to post your question on some SQLLite-related forum