Skip to main content

Send a powershell object straight to SQL Server


Recently I needed to copy directory contents details to an SQL Server.

This is the powershell script I used to do it.



$path = "C:\Files\"

$Table  = Get-ChildItem -Path $path |  Select-Object Name , FullName , CreationTime , Length

Write-SqlTableData -ServerInstance "PBRUCE-DT" -DatabaseName "PlayDatabase" -SchemaName "dbo" -TableName "FileInfoArchive" -InputData $Table  -Force

Comments

Post a Comment

Popular posts from this blog

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)
Post a Comment
Read more