Questions on database Sync

Posted on 2004-09-29
Last Modified: 2010-04-23
I have a questions reguarding upddating a local database from a server drive.  I have created an offline / online application.  When the app starts it verifies if it can get to the server, yes - online, no- offline,  I copy of a 485mb database is loaded from cd at start.  What are my options to update the local database when the user knows they are online, and send only changes.


Question by:malanois
  • 5
  • 3

Expert Comment

ID: 12179425
you want to update records or the whole database?

Author Comment

ID: 12179481
Update the records.

Expert Comment

ID: 12179540
ok, then wich sql tool are you using? sql server? access? oracle?

if you use oracle or sql server or any sql tool that can use stored procedure,  you can just create a stored procedure that takes parameters representing all field you want to update.

you can also use directly the update statements from your program to the server.


Expert Comment

ID: 12179547
oh and the stored procedure has to old the update statement to ;-)
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.


Author Comment

ID: 12179819
The databse is access.

Accepted Solution

DimYanChatelAsDataSet earned 500 total points
ID: 12179947
ok, then just  use the UPDATE statements trought your program, you know how to send sql trough vb?

the way of sending UPDATE is just as a regular SELECT statement.

Author Comment

ID: 12180732

Is ther anyway to show how many rows were updated.


Expert Comment

ID: 12181791
actually, you can only update one row at a time but maybe my knowledge is not that advanced.

is this solution ok for you?

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Introduction When many people think of the WebBrowser ( control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 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

18 Experts available now in Live!

Get 1:1 Help Now