SQL Migration Scripts Manager

A full-stack web application for managing SQL migration scripts across multiple projects and environments.

Features

• Authentication & Roles: Developer and Manager/Admin roles
• Project & Sprint Management: Create and manage projects and sprints
• Script Management: Upload, track, and manage SQL scripts
• Approval Workflow: Manager approval for production deployment
• Dashboard: Comprehensive view of all projects and script statuses
• File Upload: Drag-and-drop SQL file upload
• Status Tracking: Doing → Done → Deployed workflow

Tech Stack

• Frontend: Angular with PrimeNG
• Backend: .NET Core Web API
• Database: SQL Server
• File Storage: Local folder structure

Project Structure

scripts_manager_app/
├── backend/                 # .NET Core Web API
├── frontend/                # Angular application
├── database/                # Database scripts and migrations
├── docker-compose.yml       # Docker configuration
└── README.md               # This file

Quick Start

1. Prerequisites:

   • .NET 8.0 SDK
   • Node.js 18+
   • SQL Server (or Docker)
   • Angular CLI

2. Backend Setup:

   cd backend
   dotnet restore
   dotnet run

3. Frontend Setup:

   cd frontend
   npm install
   ng serve

4. Database Setup:

   • Update connection string in appsettings.json
   • Run migrations: dotnet ef database update

Docker Setup

docker-compose up -d

API Endpoints

• /api/auth - Authentication
• /api/projects - Project management
• /api/sprints - Sprint management
• /api/scripts - Script management
• /api/approvals - Approval workflow

Default Users

• Developer: dev@company.com / DevPass123!
• Manager: manager@company.com / ManagerPass123!