synchronizing desktop application data/information with website information

This how i am planing to synchronize my desktop  application with my website.

1. I have created a text file.
2. every time a user inserts or updates a record - the sql statement is added to the text file.
3. On closing the application or when the user desires that text file is uploaded to the ftp on the website domain

The when the websites is opened , it check if there any new files.
It runs the statements in text file, executing one at a time to update the website database.
The the website user can view data and also run reports.

I have a feeling there are likely to be better ways i can do this, help please

Anthony
LVL 1
Anthony MatovuBusiness Analyst, MTN UgandaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What database does your website use? In many cases you can directly connect to that database and update it from the desktop.
0
Anthony MatovuBusiness Analyst, MTN UgandaAuthor Commented:
Thank you Scott,
It is using sql-server, applications are developed using vb.net

Anthony
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you connect to the web database remotely? Some hosts allow this, but others don't.

If you can connect to the web database, you can open a connection to that web database and update it at the same time you update the local database.
2
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Anthony MatovuBusiness Analyst, MTN UgandaAuthor Commented:
i think i need to contact the provider about the remote connection.  do i use a normal connection string with an IP address. i know they gave me an FTP.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There's different ways to connect, including using an IP address. You can sometimes use a direct address, like 'server.blah.com", or you can use the IP address. See www.connectionstrings.com for various methods to use when connecting.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
it_saigeDeveloperCommented:
*NO POINTS*

I concur with what Scott has suggested.  The better way to communicate with your website is either being able to connect directly with the DB or using an API route which accepts the type of message you wish to transmit.

-saige-
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.