SQLServer

Connect to SQLServer and manage all your databases, execute custom queries, import and export data, create and execute stored procedures.

Read this in other languages: English, Português, Español

How to install this module

To install the module in Rocketbot Studio, it can be done in two ways:

1. Manual: Download the .zip file and unzip it in the modules folder. The folder name must be the same as the module and inside it must have the following files and folders: _init_.py, package.json, docs, example and libs. If you have the application open, refresh your browser to be able to use the new module.
2. Automatic: When entering Rocketbot Studio on the right margin you will find the Addons section, select Install Mods, search for the desired module and press install.

Overview

1. SQLServer Connection
   Connect to SQLServer database

2. Query SQLServer
   Make a query to a SQLServer database

3. Insert SQLServer
   Insert data in a SQLServer database

4. Export data
   Export data from a SQLServer database

5. Import data
   Import data to a SQLServer database

6. Create a SP with variables
   Create the Store Procedure with variables

7. Get SPs
   Get the available Store Procedures

8. SP to execute
   To see the SPs you must connect to the DB and do not close the conection until you selected the Store Procedure

9. Delete a SP
   Delete the indicated Store Procedure

10. Close connection
    Close the connection to SQLServer

---

OS

• windows
• docker

Dependencies

• sqlalchemy- pyodbc

License

MIT