What is the fastest way to move a datatable up to a MSSQL Server.
I have created a datatable in memory that is created from various souces.
When I am done I want to load this table into my MSSQL server.
Right now I do it by reading 1 line at a time from the datatable and I do an insert into the MSSQL.
Is there a faster way to load the Datatable to the MSSQL?
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.