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

I did have the same problem with excels exported from SSRS. Haven't tried to fix it beyond opening the excel and saving it again with excel

• This reply was modified 6 years, 1 months ago by Jo Pattyn.

Which version of SSMS is it? because is has been decoupled from the sql server installation. 18.4 , ... ?

--to be validated
--cte or tablealias for selfjoin
WITH TABLEDATA AS
(
SELECT ...
FROM TABLE_DATA
)
SELECT TYTD.COLUMNS, TMTD.COLUMNS
FROM TABLEDATA TYTD
LEFT JOIN TABLEDATA TMTD
ON TYTD.NAME=TMTD.NAME
AND TYTD.COMPANY = TMTD.COMPANY
AND TMTD.Flag='MTD'
...
WHERE TYTD.Flag='YTD'; 
--also possible
SELECT YTD.columns,...

• This reply was modified 6 years, 2 months ago by Jo Pattyn. Reason: where flag

Reasons to use SSIS:

• Already made a large investment
• Drag-drop synchronisation. If A+B complete, run C
• Microsoft Oracle SSIS - driver (speed improvement over the normal Oracle OLE DB driver)

...