Datasets Joining
-
What would the most efficient way be of doing this. I have a local database and a web database. My application has a dataset for the local DB and the Web based one. At regular timed intervals say every 30 minutes I want to compare the web database with the local database and download any of the latest records and then upload any modified records from my local store. What would be the best way of doing something like this ?? Any suggestions would be greatly appreciated.
-
database servers offer a process called replication. you can consult your database documentation on the matter.
also, you can write your own service that will check from time to time what changed and synchronize the databases, but why re-invent the wheel?
regards,
bogdan
-
You could use a DataView on the Web app
Dim dv As DataView = New DataView(YourDataTableHere)
By using the dataView you have far greater control over the two applications, they are essentially working in tandem, but the data remains separate until you confirm all changes made to the DataView. I would suggest you read MSDN documentation just to make sure it is suitable for your scenario.
The best point about DataViews is that you have great control over the types of modifications made; such as added, modified or deleted.
Post a reply
Quick links
Recent activity
- arif ahmad replied to How to receive data in web ...
- William Thompson replied to What is the name of the Win...
- Sameera Piyadigamage replied to Point of Sale Developers: H...
- Scott Carline replied to 4 x C# Developers for large...
- Rajendra Dhakal replied to Restore SQL Server text dat...
- cloud rainda replied to How to convert between TS f...
Enter your message below
Sign in or Join us (it's free).