We help IT Professionals succeed at work.

Update website from a desktop application

99 Views
Last Modified: 2020-05-15
Seeking guidance on uploading/update website database

I have a desktop application/software developed in Visual Basic.net.  This application is supposed to regularly supply information to a website for reporting and review purposes.

Help tell me if my plan is good or i should have a better way of implementing this

Website is built in JAVA (Servlet,JSP on Tomcat and mysql)

This is how I plan to do it.

a. Desktop (database is in access)
   1. Get all new records or updates from the desktop database since last last data upload.
   2. Transform identified records into an XML format file.
   3.Upload the XML file to the website using FTP and the software

b.server/website (database is in MYSQL)
    1.identifies all new and un extracted xml files
    2.Extract XML files to mysql database
    3. generate reports

Thanks
Comment
Watch Question

bbaoIT Consultant
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott FellDeveloper
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
gr8gonzoConsultant
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2016
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2016
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Fractional CTO
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.