AbstractsComputer Science

This project is a courseware, which will help students learn and implement web based reporting using Microsoft SQL Server and its features. Microsoft SQL server is a very huge and extensive database, which lets a user use it with flexibility of choosing the features as per their requirement. One of such feature is SSRS (SQL server reporting services) which can be widely used to create reports through report builder tool and make it available on web with Report Server available with SSRS. There is also role-based access to these reports through web, which is elaborated through this project. The implementation has been done using Company database schema having different tables with relationships and constraints for implementing and exploring with creation of different types of reports. For data, we have used .csv files to upload data into the database. With the scripts, it reduced a lot of time involved in entering data. This data is then used for creating reports. The report contains the detailed steps along with examples including installation, designing of database schema and generating reports. v This will help students use SQL Server Databases and its services in more fruitful way for creating wizard based or manual reports. Through this project we have also explored another feature of SQL Server that is SSIS (SQL Server Integration services). SSIS is used to load data from MySQL to SQL Server. The SSIS incremental load keeps database updated on periodic basis and this data is further used in the report generation. The steps and guidelines for implementing the database migration with package creation are stated in the report.