Description
This repository contains WiNGS central databse which refers to WiNGS_CDB.
Dependencies
- SQL Server Management Studio (SSMS)
- SQL Server Data Tools (SSDT) for Visual Studio 2017
- Visual Studio 2017
Getting started
- Install SQL Server 2019 Developer Edition
- Create required databses
- run script 'WiNGS_Db'
- run script 'WiNGS_data_Db'
- run script 'WiNGS_BaseInfo_Db'
- Populate the databases with the necessary information
- run script 'script_populateTable'
- run script 'BaseInfo_DB'
- Install SSIS in SQL server and create Integrated Service Catalog
- Deploy SSIS projects in SQL Server (all projects under SSIS folder)
- Create SQL Jobs in SQL Server Agent
- run script 'WiNGS_Job'
Contacts