powahxel

[system.reflection.assembly]::LoadWithPartialName("MySql.Data")
$mysql_server = "localhost"
$mysql_user = "USERNAME"
$mysql_password = "PASSWORD"
$mysql_database = "siconv"

write-host "Criando conexão com siconv"
$conexao = New-Object -TypeName MySql.Data.MySqlClient.MySqlConnection
$conexao.ConnectionString = "SERVER=$mysql_server;DATABASE=$mysql_database;UID=$mysql_user;PWD=$mysql_password"
$conexao.Open()

write-host "Executando o Script"
$comando = New-Object -TypeName MySql.Data.MySqlClient.MySqlCommand
$sql = (Get-Content "\\srvdmd\PUBLICA\sistemasiconv\PESQUISAS\IMPORT_CSV.sql")
$comando.Connection = $conexao
$OFS = "`r`n"
$comando.CommandText = $sql
$comando.ExecuteReader()

write-host "Fechando a conexão"
$conexao.Close()