import-sql-files.ps1

$MachineName = $env:computername
$InstanceName = "SQLEXPRESS"
$ServerInstance = "$MachineName\$InstanceName"
Get-SqlInstance -ServerInstance $ServerInstance

# Provide SQLServerName
$SQLServer = "MySQLSErver\InstanceName"

# Provide Database Name 
$DatabaseName = "my-db-name"

# Scripts Folder Path
$FolderPath = "c:\sql-files\"

# Loop through the .sql files and run them
foreach ($filename in get-childitem -path $FolderPath -filter "*.sql")
{
    invoke-sqlcmd -ServerInstance $ServerInstance -Database $DatabaseName -InputFile $filename.fullname

    # Print file name which is executed
    $filename 
}