装pyodbc的方法是,用命令行进入python目录下的Scripts文件夹,输入“pip install pyodbc”
示例代码:
import pyodbc
from datetime import datetime
g_ip = '20.30.1.54'
g_user = 'sa'
g_pwd = 'lalala@44444'
g_database = 'date_sys'
back_path = 'C:\\'
back_path = back_path + g_database + datetime.now().strftime("%Y%m%d") + '.bak'
#报错提示42000的原因就是这里没有加autocommit的设置
cnxn = pyodbc.connect(DRIVER='{SQL Server}',SERVER=g_ip,DATABASE=g_database,UID=g_user,PWD=g_pwd, autocommit=True)
sql = "BACKUP DATABASE [{0}] TO DISK = N'{1}'".format(g_database,back_path)
cursor = connection.cursor().execute(sql)
while cursor.nextset():
pass
connection.close()
参考文档:https://stackoverflow.com/questions/20067012/how-to-backup-a-database-by-pyodbc