SQL Anywhere database replication - Replication of Parent/Child Relationships

Author

Replication of Parent/Child Relationships

Brian McGinnis

2005-09-13, 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

Rob Waywell

2005-09-14, 1:23 pm

What have you tried so far?
What is it not doing for you?

If you can show us your current publications and UPDATE ... PUBLICATION
statements then we will be able to provide more input.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
<Brian McGinnis> wrote in message
news:43272c5f.4888.1681692777@sybase.com...
>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