Solved

Questions on database Sync

Posted on 2004-09-29
8
202 Views
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.

Thanks,

MJ
0
Comment
Question by:malanois
  • 5
  • 3
8 Comments
 

Expert Comment

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

Author Comment

by:malanois
ID: 12179481
Update the records.
0
 

Expert Comment

by:DimYanChatelAsDataSet
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.

0
 

Expert Comment

by:DimYanChatelAsDataSet
ID: 12179547
oh and the stored procedure has to old the update statement to ;-)
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:malanois
ID: 12179819
The databse is access.
0
 

Accepted Solution

by:
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.
0
 

Author Comment

by:malanois
ID: 12180732
Ok,

Is ther anyway to show how many rows were updated.

0
 

Expert Comment

by:DimYanChatelAsDataSet
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?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

914 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

16 Experts available now in Live!

Get 1:1 Help Now