Re: Reality check

From: Sean M. Severson (sseverson_at_nerdsolutions.biz)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 12:50:02 -0600

Paul,

Interesting idea. So, I would need to add a field to each table to store
the sync date and then use this to determine which records have changed and
run a query to update existing records or insert new records. I have
experience keeping tables synchronized (manually) in MS Access. I was under
the impression that SQL Server was going to be more difficult.

Thanks.

Sean M. Severson
Software Technology Solutions, LLC

"Paul Nielsen" <pnielsen@us.ci.org> wrote in message
news:%23fGbqUl0EHA.3704@tk2msftngp13.phx.gbl...
> Keeping two database in sync with different schema is tricky, but it can
be
> done. Think of it as two ETLs to a data warehouse. I recommend getting one
> database pushing to the other smooth before going two-way.
>
> columns: Sync, Updated
> use a trigger to update the updated column with every update. And deafult
it
> to getdate() for inserts.
>
> 1) set @SyncNow = GetDate()
>
> 2) update table
> set sync = @Syncnow
> Where updated > sync
> 3) push all rows with the synch = @syncnow to the other server using a
query
> to transform the data to the otehr serve's schema.
>
> --
> -Paul Nielsen, SQL Server MVP
> SQL Server 2000 Bible, Wiley Press
> Enterprise Data Architect, www.Compassion.com
>
>
>
>
> "Sean M. Severson" <sseverson@nerdsolutions.biz> wrote in message
> news:OwnmlHl0EHA.1400@TK2MSFTNGP11.phx.gbl...
> > Could someone please verify that what I want to do with sql server is
> > possible (I'm new).
> >
> > I have two different sql server databases that contain contact
> > information.
> > I need to keep the contacts synchronized. However, the formats of the
> > contact tables are different and the databases are from different
vendors
> > (commercial software). I need to update certain contact information in
> > one
> > database when an addition or change is made in another database. Can I
> > use
> > a trigger on one contacts table to insert a record into another contacts
> > table? I would need to use the contact information that was just
inserted
> > or modified.
> >
> > Thanks for your help.
> >
> > Sean M. Severson
> > Software Technology Solutions, LLC
> >
> >
>
>

Relevant Pages

  • Re: Wireless Synchronization
    ... desktop database and PPC database. ... Directly Querying SQL Server using SqlClient (Bit Slow while ... Web Services ... Services as the sync option. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: How to limited number of rows in a table?
    ... If this is a log table, database blocking should ... Pro SQL Server 2000 Database Design ... > I'll bend on the trigger, but I think a nightly job may be too infrequent ...
    (microsoft.public.sqlserver.programming)
  • Re: How to Synch up a device and desktop
    ... desktop database and PPC database. ... RDA or Merge Replication of SQL CE (RDA is Good to start with, ... SQL Server CE takes up memory if stored in CE tables ... Services as the sync option. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Trigger: To fill another Database with using Stored Procedures of the other Database
    ... I fill from Database A with triggers Database B, ... add additional information accordingly, this Stored Procedures is ... trigger does not work anymore, even if I do a try catch over the whole ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Alternatives to SQL Server Mobile?
    ... Intellisync offers robust database sync between SQL Mobile, ... > However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)