Meer-Web
/
sql_queries_via_powershell
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
2 Commits 1 Branch 0 Tags 26 KiB
PowerShell 100%
Go to file
Frank Bischof c947c7ed39 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_queries.ps1 Renamed Sqlfile variables 2023-04-28 14:41:52 +02:00

README.md

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.