developer edition? Ain't free for production

Haven't tried openquery yet regarding batchsizes and character limits.

Anyway, the switch to ado.net solved the slowness problems for now until the switch to sql 2019

On your UAT server, restore the databases with the same compability.

You could try out https://spaghettidba.com/tag/workloadtools/ for capturing / replay the SQL on the UAT.

Saw a demo at dataminds connect. You...

Thanks for mentioning that Powershell 7 is out

Thanks frederico_fonseca and Jeff Moden for the extensive feedback.

I'm transfering 160 million rows of oracle 11g number (19,0) not null to sql server numeric(19,0) not null

Using SQL 2017 Enterprise +...

Awaiting SQL 2019 backup support, trying with the ado.net driver. Doesn't seem to go slower after a while

You can trace filegrowth with extended events https://www.sqlservercentral.com/blogs/finding-file-growths-with-extended-events

Fun, database with thousands of tables and no foreign keys

Things that are interesting in SQL 2019 are the accelerated database recovery and the new oracle driver for SSIS (preview)

Also verify the host-configuration as the processor is virtualized (Common KVM) it must run on some host. Is power-saving disabled ? how are the resources distributed between VM's? Are the...

You can try

Invoke-Sqlcmd -ServerInstance "$serverinstance" -database "Gestion_BO_Stats" -Query "exec SP_EQUITE_SANTE_CDC_Contrats" |export-csv -path "$path\SP_EQUITE_SANTE_CDC_Contrats_$((Get-Date).ToString('MM-dd-yyyy_hh-mm-ss')).csv"

as powershell variables are expanded when used between double qoutes

How do you did it?

Why not rename the logins / logingroup with ALTER LOGIN ...  to keep the same SID ?

Can anyone recommend a powershell forum? Invoke-webrequest loses some of its parsing in powershell 6 (especially the forms part)

Perhaps you can start with readcommited snapshot isolation instead of in-memory? The optimistic locking should reduce blocking from reporting

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server