Mithrandyr
Mithrandyr
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html This supports bulk loading from a file. Consider Adding a Connection level attribute (use alternative-loading) and then in Invoke-SqlBulkCopy write out the information to disk, then process the file...
If there is an existing transaction (with the MSSQL provider) and invoke-sqlbulkcopy is used, an error is thrown because the bulkcopy class is not expecting this. Suggestion: modify the code...
The SqlBulkCopy class by defaults uses the option "Keep Identity" -- which requires `alter table` permissions. There are additional options that, if not specified, require `alter table` permissions. See Microsoft...
`-SSLMode` has the following enumerations: `Disabled`, `Preferred`, `Required`, `VerifyCA`, `VerifyFull`. However, the first enumeration `Disabled` is invalid, it should be `None`. See [SSL/TLS Options](https://mysqlconnector.net/connection-options/) (you will have to scroll down).
**this is present pre 2.0, but missing afterwards:** -NotifyAction If specified, then on the completion of each batch, this action will be invoked. The first argument will have the rows...