A package to run SQL script or SQL file script in an instance of sql server
Project description
py-scripto
This is to run SQL script or file script in an instance of sql server
Installation:
python -m pip install py_scripto
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 import 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)")
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
py_scripto-0.1.4.tar.gz
(2.0 kB
view hashes)
Built Distribution
Close
Hashes for py_scripto-0.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 630172f518ceae153e969ad68298d58fb351e2e8b632369defe650ca98f7fcc4 |
|
MD5 | 4e83fc1234739c4c3b0db83d245edba8 |
|
BLAKE2b-256 | ef7c8a0c9b8210ada7b23a23de4a20d21665eaab6fc7eec64165f11ed62664a9 |