OD-DD sync - best practice?

System

I'm looking at dojng a DD-OD sync and was wondering what the best practices are for this?

Basically, I need to send data, database tables and views (which I've created) to the following places:
data (DCR's) need to deploy to two servers
database tables/views need to deploy to one database server

In looking at the forum posts - it appears that ddgen.ipl generates the loaddb.cfg?

then tsxml.cfg - is used to deploy the DCR's

In all the manuals I have - documentation is very sketchy on usage of these mechanisms - what is the best way to achieve what I want to do?

Migrateduser

another source of documenation is the readme bundled under the od-home/solutions/ddsync directory. this readme explains some of the mechanics involved in an OD-DD sync.
the readme has been updated of late in recent service packs.

the bundled solution assumes a 3-tier model,
(ie. sender-to-reciever-to-db) and only a single leg at that,
so only 1 db and 1 file server coupling.

what you may want to consider is building a transactional
2 definition deployment, each going to your respective target
file servers, and have one of the definitions execute
a DNR script that invokes DD to populate your database.
This DNR can be a sender-side-after-deploy DNR, so
that if the DNR script exectuon of the DD part fails the script
can write response code=-2 to tell OD to rollback the file
content.
Esssentially you can do a simpler version of ddsync.ipl.

If a 3-tier model is what you need, then read the readme
and implement it for one fileserver-db coupling.... and
have another def for the other fileserver.
And I would recommed using UDS deployments
instead of wide-table deployments.

Wide-table deployments make use of the tsxml.cfg
and loaddb.cfg DD configs, with the former used to
have the sender-side DD create transient dump files
to be OD'd over, and and latter used to have the
target-side DD read these dump files to update the database.
If you use UDS, you wont need these, unless you want to deploy Teamsite EA's too. DD is smart enough now to read
the DCR files directly and update the database.

Hope this is enough info to get you started.