transformations:exportdb
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
transformations:exportdb [2020/01/22 12:59] – dmitry | transformations:exportdb [2020/01/22 13:04] – dmitry | ||
---|---|---|---|
Line 7: | Line 7: | ||
Export will convert cell values only in the following cases: | Export will convert cell values only in the following cases: | ||
- | * Boolean cell to a numeric column | + | * Boolean cell to a numeric column |
- | * Numeric cell to a date or a datetime | + | * Numeric cell to a date or a date/ |
- | * Any cell to a text column or a column of unknown type - will be exported as text | + | * Any cell to a text column or a column of unknown type is exported as text literal |
- | * Error cell will be always exported as null | + | * Error cells are always exported as NULL |
- | In all the other cases when cell type doesn’t match column type a NULL value will be exported. | + | In all the other cases when the cell type doesn’t match the target |
- | |||
The operation is //atomic// meaning that it either successfully exports all rows, or nothing (in case of failure). | The operation is //atomic// meaning that it either successfully exports all rows, or nothing (in case of failure). | ||
Note that the operation effectively //appends// rows to existing ones. If you need to remove old data use the [[sqlcommand|Database command]] action. | Note that the operation effectively //appends// rows to existing ones. If you need to remove old data use the [[sqlcommand|Database command]] action. | ||
- | Some databases have performance bottleneck for batches of SQL INSERT statements which may lead to slow performance (especially on wide tables). Consider using bulk load statements | + | Some databases have a performance bottleneck for batches of SQL INSERT statements which may lead to slow performance (especially on wide tables). Consider using bulk load statements |
==See also== | ==See also== |
transformations/exportdb.txt · Last modified: 2023/10/14 16:20 by craigt