Meer-Web
/
sql_queries_via_powershell
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
sql_queries_via_powershell/README.md

532 B
Raw Permalink Blame History

Monthly SQL Query automation

Description

You can set the DB server and database in the config part of the script. You can specify settings:

$SQLServer = "dbserver1"  
$SQLDBName = "database"  
$delimiter = ";"

The SQL files queried for are:

$SqlFile = 'Query file 1'
$SqlFile = 'Query file 2'
$SqlFile = 'Query file 3'

These SqlFiles corespond to ea. "Query file 1.sql" and will be output to 'YYYYMMDD/Query File 1.csv' The script uses your windows credentials to log in to the server and execute the queries.