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

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more