...
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> |
|
Step 4:
The changeset is now eligible to be deployed to the various databases on the pipeline. If you are using artifacts, be sure the package the changelog updates prior to running any deployments.
...