Go to file
2023-04-28 14:41:52 +02:00
monthly_sql_queries.ps1 Renamed Sqlfile variables 2023-04-28 14:41:52 +02:00
README.md Initial release 2023-04-05 11:53:25 +02:00

Monthly SQL Query automation


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.