SQL Anywhere database replication - Replication with Parent/Child Relationships

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Replication with Parent/Child Relationships

exdivio@gmail.com

2005-09-12, 8:23 pm

I have a series of relationships like:

Entities --> Contracts --> Deliveries

I want to set up a publication that is in use for a couple of months
out of the year annually based on a year field that is stored in the
Entities table.

For example, something that would setup a publication that included all
entities and their corresponding Contracts and Deliveries from 2004 to
current.

I started to use a WHERE clause on each table, but the year is only
stored in the Entities table...

Any help would be appreciated,
-Brian

Sponsored Links