...
Note you can include changeset attributes such as labels and contexts.
See Valid Data Types for supported values.
| Code Block |
|---|
<changeSet author="Kevin" id="2024-06-25-data-load-1">
<loadData encoding="UTF-8" file="data/contacts.csv" tableName="contacts" schemaName="dbo">
<column header="id" name="id" type="NUMERIC"/>
<column header="activeflag" name="activeflag" type="BOOLEAN"/>
<column header="firstname" name="firstname" type="STRING"/>
<column header="lastname" name="lastname" type="STRING"/>
<column header="age" name="age" type="NUMERIC"/>
<column header="lastcall" name="lastcall" type="DATETIME"/>
</loadData>
</changeSet> |
|
...
Note you can include changeset attributes such as labels and contexts.
See Valid Data Types for supported values.
| Code Block |
|---|
<changeSet id="2024-06-25-contacts-data-update-1" author="Kevin" >
<loadUpdateData
encoding="UTF-8"
file="data/updated_contacts_1.csv"
tableName="contacts"
schemaName="dbo"
primaryKey="id">
<column name="id" header="id" type="NUMERIC"/>
<column name="activeflag" header="activeflag" type="NUMERIC"/>
<column name="firstname" header="firstname" type="STRING"/>
<column name="lastname" header="lastname" type="STRING"/>
<column name="age" header="age" type="NUMERIC"/>
<column name="lastcall" header="lastcall" type="DATETIME"/>
</loadUpdateData>
</changeSet> |
|
...