Re: Databases Sync Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

I would mark them 'D' then run the query to gather the data to a file and
then delete it, a 2 step process.
Alternatively you can create a repository table to Archive Deleted Data by
using some event ttrigger on the main table that causes the row (to be
deleted) to be copied into the repository before purging it.

Log shipping is more or less similar instead it uses the sql log file .ldf
to record all the transactions that has occured in the db. you can ship the
..trn file and restore the db on the other end using this .trn file.



"Guy" <Guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:65914382-DDB2-4515-A3D9-A131B7C37E40@xxxxxxxxxxxxxxxx
Many thanks.

in the second case (using flags) A(dd), C(hange) flags are pretty clear.
But
the D(elete) flag when should the record flagged with a D flag effectively
become deleted from the table?

Guy


"VBeachcomber" wrote:

Options:

1. Implemet Log Shipping.

2. Alternate method: use Flags( 'A','C','D') to mark rows that were
added,
changed/update and delete by altering the table schema to accomodate the
extra column. Grab all the data corresponding to A.C.D flags. Transport
the
files however way u want and then write a proc to update your db or
design a
DTS to do the same.

Just a thought.

Beachcomber

"Guy" <Guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7A04179B-92EF-4596-9257-00966EB455B3@xxxxxxxxxxxxxxxx
I forgot to mention, the schemas of both db's are the same.

"Guy" wrote:

First of all I suppose this is the correct forum for my question. If
not
tell
me pls which one is more appropriate.

I want to synchronize several tables of 1 local db (SQL Compact) with
a
server db (SQL Server Standard) via an ADSL connection (over the
Internet). I
want to achieve this in a simple way by sending ONLY the
new/modified/deleted
records (by means of an XML file) to a server stored procedure.
To select only the new and modified records in my local db, I could do
this
by having an extra column with a timestamp. This timestamp is
filled-in
when
a new record is entered or a record is modified. Based on the last
sync
datetime I could tha way select the impacted records (new/modified).
BUT,
how
should I treat deleted records??? They're deleted from my local db,
and
since
I'm only sending a delta of the records (=not all) how can the server
db
know
which records are deleted in my local db???

Other approaches to solve my problem are also more than welcome.

Thanks.





.

Relevant Pages

  • Re: storing raw SQL
    ... "Mark" wrote in message ... all our applications have used stored procedures against SQL ... > Server for data access. ... > and need to pass raw SQL queries. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: query analyzer
    ... I did a quick search of my registry and I found some entries under ... "Mark" wrote in message ... > login/password and the server you want to connect to. ... > reinstall SQL Server client tools. ...
    (microsoft.public.sqlserver.programming)
  • Re: Databases Sync Question
    ... I suppose after the sync has been done the flags ... Log shipping is more or less similar instead it uses the sql log file .ldf ... server db via an ADSL connection (over the ...
    (microsoft.public.sqlserver.replication)
  • Re: RollBack im Multiuserbetrieb
    ... Access und wahlwese SQL Server als backend und das trat nur mit SQL ... Gruss - Mark ... Bitte keine eMails auf Newsgroup-Beiträge senden. ...
    (microsoft.public.de.access)
  • Table Extents ?
    ... Who do you determine the number of table extents in a SQL ... Server 2000 database? ... Mark ...
    (microsoft.public.sqlserver.server)