Simple DSL for defining Document structures from Relational Data

extract.xml

<?xml version="1.0" encoding="UTF-8"?>
<Extract>
    <Orders>
        <Order DateCreated="2012-03-21" CustomerNumber="1234">
            <OrderLine Qty="2" UnitPrice="15.00" ProductCode="TAC123" />
            <OrderLine Qty="45" UnitPrice="0.15" ProductCode="TAC321" />
        </Order>
        <Order DateCreated="2012-03-21" CustomerNumber="5678">
            <OrderLine Qty="9" UnitPrice="27.00" ProductCode="TAC987" />
        </Order>
    </Orders>
</Extract>

sample.plan

local: server=.\sqlexpress; database=Sample; Integrated Security=SSPI;
uat: server=MY_SERVER; database=Sample; Integrated Security=SSPI;

[MapPoints]
MapPoint
    >Address
        @State Name

[Orders]
Order
    @Customer CustomerNumber
    <OrderLine
        @Product ProductCode

usage

C:\fl.exe pull uat extract.xml orders -planFile sample.plan

Extracting orders from UAT environment and storing in extract.xml

C:\fl.exe push local extract.xml orders -planFile sample.plan

Reading extract.xml and pushing orders into LOCAL environment