Skip to content

markogajicgithub1997/Python-SQL-Server

Repository files navigation

Python

In thin project i used Tkinter (Python gui). For connection between Application and SQL SERVER Databse i used Pyodbc.

SQL Server

DB that i used is Microsoft SQL Server. Created tables,triggers,procedures,schemas,horizontal and vertical partitions.

Usage

To set database ,go in SQL Server Managment Studio then File -> Open -> File and open Database(from downloaded) -> Baze2BoxDB(sql file) then Execute it. To successfully connect to databse go into file 'Konekcija.py' and change Driver and Server for your device. Go into 'boxposloviprojekat.py' press right click on any part of code screen than click 'Run Python File in Terminal' and it will run application.

About application

I made this application for a 'Database 2' subject in my faculty master degree. Shows CRUD operations on Database from GUI.

About

Python (Tkinter,Pyodbc) + SQL Server App

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published