MS SQL restore databse from python through windows commands

Question

I want to restore DB on MS SQL Server 2008 using python3.2/tkinter. Do I have any commands that would rename(if it exists already) DB and then restore it. How can I do it from python only?

Thanks

Ruslan Osipov · Accepted Answer · 2013-03-27 23:28:26Z

1

You can simply use _mssql from pymssql.

import _mssql

conn = _mssql.connect(server='', user='', password='', database='')
conn.execute_non_query("IF EXISTS (SELECT 0 FROM sys.databases WHERE name = 'mydb') BEGIN ALTER DATABASE mydb MODIFY NAME = mydb_old END")
conn.execute_non_query("RESTORE DATABASE mydb FROM DISK='C:\mydb.bak'")

Quick, MSSQL-y and easy.

answered Mar 27, 2013 at 23:28

Ruslan Osipov

5,8734 gold badges31 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Aashiq Hussain Over a year ago

Actually, I just have pythone3.2 only. Its is on office server, They won't let me install extra modules etc. I guess there are windows commands for SQL Server that would let you back-up and restore DB from command prompt?

Ruslan Osipov Over a year ago

@AashiqHussain There is sqlcmd utility, which you can pass commands to I guess: cyberciti.biz/faq/howto-ms-sql-list-tables-and-database

Aashiq Hussain Over a year ago

I want to execute commands without entering user name and password. I would like to execute it as current logged on user. How to that stuff from a python script. Thanks for the response.

Ruslan Osipov Over a year ago

@AashiqHussain Just sqlcmd -S <server>. First result on google.

Collectives™ on Stack Overflow

MS SQL restore databse from python through windows commands

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related