Documentation: https://docs.google.com/document
Video demonstration: https://docs.google.com/video-demonstration
sql-source-control repository: https://github.com/madchavez/sql-source-control
Source Control plugin download: https://www.devart.com/dbforge/sql/source-control/download.html
-
The SQL Database must be cloned from the sql-source-control repository (check in links).
- Clone the repository to a local folder using cmd
- Command:
git -clone https://github.com/madchavez/sql-source-control.git
- Command:
- Download the Source Control plugin for SSMS (check in links).
- Open SSMS and create a database and name it "LibDat"
- Link your local database to the repo database.
- Right-click on the database and under "Source Control" click on "Link Database to Source Control"
- Look for "Source control repository" and click on the plus sign next to the drop-down box.
- Choose Git as the Source control system and under the "Repository folder" navigate to your local folder where you cloned the remote repository.
- Test connection and close the "Source control repository" window.
- Click on "Dedicated" for the database development model then click "Link"
- Click on the checkbox next to Remote changes and then click the "Get Latest" button.
- Clone the repository to a local folder using cmd
-
The value of globalServer in Program.cs must be modified into the name of your local server.
- public static string globalServer = "MAJO-PC";
- public static string globalServer = "DESKTOP-9MBNT14";
Section: BCS22
- Chavez, Miguel Antonio
- Dasal, Estelle Marie
- Gamit, Mary Josephine
- Uriarte, Philip Ronin
- Application created with Visual Studio 2022
- Database created with SQL Server Management Studio