py-scripto 0.1.0

A package to run SQL script or SQL file script in an instance of sql server

# py-scripto This is to run SQL script or file script in an instance of sql server

### Version used SQL Server 2019 Python 3.7.5

## DEPENDENCIES

### DbExec stored procedure Download from https://github.com/datnguye/SQL-Server/blob/master/maintenance/DbExec.sql Compile it to master database

### xp_cmdshell need enabling on SQL instance ` EXEC sp_configure 'show advanced option', 1 RECONFIGURE GO EXEC sp_configure 'xp_cmdshell', 1 RECONFIGURE GO `

## USAGE

` from py-scripto.sqlserver sqlserver.run_file_script(server="DAVID\DAVID", uid="py-scripto", pwd="py-scripto", connect_to_db="IMPORT", script_path="D:\\Downloads\\test.sql") sqlserver.run_script(server="DAVID\DAVID", uid="py-scripto", pwd="py-scripto", connect_to_db="IMPORT", sql="SELECT * FROM Test WITH (NOLOCK)") `