Re: Database Sync Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

and wouldn't work out well.

Which; SqlDependency? I agree... minimising the data you need at the
client, however, seems pretty OK ;-p

And I want to minimize network traffic.

So why drag an entire table over? Keep the data at the server, and
just hold conversations with it - either to the database server
itself, or a web-service.

If you really must do it your way, then a delete trigger that pumps
into a "deleted" table may be of use - you can use the identity in the
table to get just the updates you haven't seen, and can purge any
values older than your supported range - perhaps half an hour. Then in
the same way that you query for updates/inserts, just query for
deletes too.

Marc

.

Relevant Pages

  • Re: Database Sync Question
    ... just hold conversations with it - either to the database server ... table to get just the updates you haven't seen, ... the same way that you query for updates/inserts, ... Yeah thats an interesting idea. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: TableAdapter.Update fails with missing parameter
    ... Select Query). ... And that worked and then the Updates started working. ... I see that when I enter a new value in the bindingNavigatorPositionItem ... Thus, VS IDE generates GridView ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Update/Append/AddColumn
    ... K Dales wrote: ... everything - even your update/append query - the way it is, ... run your query find any matching employee records by joining your imported ... Then when doing the updates, instead of overwriting the wage info mark the ...
    (microsoft.public.access.queries)
  • RE: Update/Append/AddColumn
    ... everything - even your update/append query - the way it is, ... run your query find any matching employee records by joining your imported ... number) and use the result as an append query that adds the OLD record values ... Then when doing the updates, instead of overwriting the wage info mark the ...
    (microsoft.public.access.queries)
  • Re: Back end database lock-up
    ... Or are you programmaticlly executing some updates in an action query or some code? ... Check the open mode and locking strategy of *each* front end. ... Default Record Locking: No Locks ...
    (comp.databases.ms-access)