asked on

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

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony Matovu

ASKER

Thank you Scott,
It is using sql-server, applications are developed using vb.net

Anthony

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony Matovu

ASKER

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.

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

it_saige

*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-