cccrontab@lemmy.worldtoProgramming@programming.dev•Anyone having acceptable performance with SQL Server + odbc?
3·
2 months agoTry BCP. I’m fairly new to the Microsoft landscape too, but found using BCP really helped with efficiency on loading.
Try BCP. I’m fairly new to the Microsoft landscape too, but found using BCP really helped with efficiency on loading.
No, it’s a standalone utility that you can download and install separate from SQL Server. It just adds BCP.exe to your command line.
Docs
Look for the link that says “Download Microsoft Command Line Utilities 15 for SQL Server (x64)”.