Having an updated base every day

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

From: Pavils Jurjans (pavils_at_mailbox.riga.lv)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 16:10:36 +0300

Hello,

I have two symmetrical databases on two SQL servers - one remote, the
other - local. The data in the remote server changes every minute. The data
in local SQL server is used for creating some reports and general testing.
Sometimes data from the local base can be irreversibly deleted.
I want to have some sort of procedure, that would do one-direction
synchronisation of the two databases. The data in the remote database should
overwrite the data in the local database, so that after the update the local
database is exact copy of the remote database. Of course, this kind of
result could be achieved by detaching the remote base and bringing over the
database files, or doing full DTS. However, detaching and transfering is not
a viable solution since the remote base is actively used and the size of
data files are considerable; And, doing full DTS would take years. There is
some need to do some comparison of record hashes etc., so that the size of
the data that have to be transfered is reduced to minimum.

Thanks,

Pavils

Relevant Pages

  • Challenging ADO.NET situation (long)
    ... need to import those records into the local database. ... depending on a "type" column in the master (ie some records ... independantly, but data is always transfered from remote to local, not the ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Challenging ADO.NET situation (long)
    ... need to import those records into the local database. ... depending on a "type" column in the master (ie some records ... independantly, but data is always transfered from remote to local, not the ...
    (microsoft.public.dotnet.framework.adonet)
  • A Way Forward?
    ... Lets say that the remote databases have an autonumber for the local computer ... reference ID in the Procurement and Purchase Order table AND another column ... but this database design seems to be a very complex problem. ... Setting incremental numbering based on Australian FY set ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Please help with remote access to FM Pro Server 7
    ... But if it is to access a database from a remote location, ... - both local and remote computers are simply connected to internet. ... on the local network. ...
    (comp.databases.filemaker)
  • Re: Help on performance question
    ... from the remote DB in a second dataset. ... database and cannot change any structure. ... I have been told that retriveind requested data in an SQL querry is faster ...
    (microsoft.public.dotnet.framework.adonet)