• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Questions on database Sync

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.

Thanks,

MJ
0
malanois
Asked:
malanois
  • 5
  • 3
1 Solution
 
DimYanChatelAsDataSetCommented:
you want to update records or the whole database?
0
 
malanoisAuthor Commented:
Update the records.
0
 
DimYanChatelAsDataSetCommented:
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.

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
DimYanChatelAsDataSetCommented:
oh and the stored procedure has to old the update statement to ;-)
0
 
malanoisAuthor Commented:
The databse is access.
0
 
DimYanChatelAsDataSetCommented:
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.
0
 
malanoisAuthor Commented:
Ok,

Is ther anyway to show how many rows were updated.

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

is this solution ok for you?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now