upload local database to a live database

Posted on 2006-05-27
Last Modified: 2008-02-26
I had a question for ya...

Hopefully it will be brief...

I have a client that is a mechanic.

He wants to have a worksheet/form that he fills out on every repair he does.

Its basically about 50 yes no or NA questions, that I will set up as radio buttons.

I believe I can handle most everything on the form and the database.

The issue That I have is that I want to set up a Laptop for him that he can use while doing the repairs.

That he can fill the form out and it will store it in a local database.

Then when he is in his office all he will need to do is upload it to his "live" website database...

Any ideas on how I could do that?
Question by:noel4nopun
    LVL 50

    Expert Comment

    which Database system are you intending to use...

    if it was SQL server then the process could be handled by merge replication...

    what is your actual scenario ...

    will the mechanic just be acting on "pulled" worksheets
    or will he actually be able to create "new" work that will also need to be inserted into the main database?

    LVL 16

    Expert Comment

    Generate a flat file or XML file. There are lots of methods to upload flat files to most databases.

    Author Comment

    I want to set it up using php and mysql

    not sure about the "pulled" but I would assume it is a new one...

    He wants to have a "PM" (which is the form of 50 or so questions), he wants a form for say 5 different types of trucks. and keep these all collected by clients.

    I am sure that the database design itself is going to keep me quit busy, But my Main concern for now is...

    I was thinking of setting apache + php + mysql on a local laptop for him to use onsite...
    And then my hopes are that he would then later be able to upload his "local" databse up to the "live" one.

    Not too sure how to approach this.

    PS I am new to expert exchange, tis is my first question and I want to thank you for getting back to me...

    LVL 3

    Accepted Solution

    Copy the local table to a disk, create an update query in the live database to update the corresponding table.

    Author Comment

    I think this idea of coping a table to the hard drive/disc then updating the database is the way to go.

    Now on to, how to figure that out.



    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This article describes some very basic things about SQL Server filegroups.
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now