Romain Ferraton
Romain Ferraton
Parallel insert would be a beneficial feature I think. To simplify thing, may be the use of ARRAY as source with partition in target may help ?
[MS SQL OUTPUT Clause ](https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-ver16) is an équivalent of RETURNING postgresql clause. It is often use for SCD loading in combinaison with the MERGE statement : https://www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-update-and-delete-at-the-same-time/ I agree with...
**I try to load data into hyper table(s) in parallel from several process.** I was asking this because of a post that [open an hyper process on a docker ](https://medium.com/starschema-blog/scaling-out-tableau-extracts-building-a-distributed-tableau-hyper-cluster-534bc6e6ba62)...
I am currently facing incompleted rows (a row full of NUL 00 ascii characters due to the mode of extraction of the original data...but nevermind) As we want to use...
> @rferraton Once your BulkCopy operation completes, can't you retrieve the RowsCopied and perform a mod 1000 operation to find out the "remainder" of rows copied? No, i don't get...
No you solution does not work. (tested) Let's imagine you have 5 rows to load and **NotifyAfter** is set to 1000 ```csharp obc.OracleRowsCopied += (sender, args) => { crows =...
i used the 3.21.130 and now the 23.2.2-dev : same problem
Thanks to push to DevTeam 👍 Agree : OracleRowsCopied Event have the behavior describe in the documentation. Agree : at the time of writing, there is no way to know...
Nope : ```SQL BACKUP DATABASE [TESTDATABASE_ABC_1eed02d4-f58b-4110-9cee-78c2fa65123a_123456789012345678901234567890] TO DISK = N'D:\MSSQLBACKUP\MSI\MSSQLSERVER\TESTDATABASE_ABC_1eed02d4-f58b-4110-9cee-78c2fa65123a_123456789012345678901234567890\Full\TESTDATABASE_ABC_1eed02d4-f58b-4110-9cee-78c2fa65123a_123456789012345678901234567890_FULL_20240506145012.bak' WITH NOFORMAT, NOINIT, NAME = N'TESTDATABASE_ABC_1eed02d4-f58b-4110-9cee-78c2fa65123a_123456789012345678901234567890-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO ``` work : 11 percent...