VijayGanji VijayGanjiDevOps
potatoqualitee
/ Test-Faf.ps1
Last active
February 24, 2021 15:11
Insanely fast CSV to SQL Server imports using the FAF technique (batched datasets and in-line multithreading)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| PowerShell, SqlBulkCopy and RunSpaces Speed Test | |
| -- To be used for speed testing purposes with million.csv -- | |
| -- Will drop and recreate specified database if it exists -- | |
| This script will | |
| - Automatically download the million row dataset if it doesn't exist | |
| - Drop the specified database if it exists |