Challenge Overview
Project Overview
Styx Dashboard aggregates and presents metrics from multiple instances (typically 12 or less) of a specific software residing on multiple physical servers.
Competition Task Overview
Right now the app is already working pretty well, but it's not easy to maintain the app since it supports using SQL Server and Oracle as application database. In order to make it easier to maintain this app we'd like to get rid of SQL Server / Oracle and switch to using SQLite as application database.
Below are the requirements for this challenge:
- Update all backend code to work with SQLite, supporting SQL Server / Oracle as application database is NO LONGER NEEDED and should be removed
- Frontend code should be updated to work with SQLite as well if necessary
- SQL scripts must be updated to work with SQLite
- Unit tests must be updated to work with SQLite
- Deployment guide(s) must be updated to reflect the change of application database
- Update the installer so that it works with SQLite, this means we no longer need the 1st configuration dialog for SQL Server / Oracle which is the application database
- NOTE: we are only changing the application database, the services still interact with external SQL Server / Oracle databases to get metrics
Solution Structure
Please follow the existing structure in the base code.
Technology Overview
- Windows 2008 R2(64Bit) is installed
- Microsoft SQL Server 2008 R2 is installed
- Oracle10g 10.2.0.3 is installe
- .NET Framework 4.0 is installed
- MS Build 4.0 is installed
- Visual Studio 2010 is installed
- Unity 3
- NUnit Framework
- ASP MVC3
- IIS 7.5+ is installed
- SQLite
Documentation Provided
Register to download documents from challenge forum.
Final Submission Guidelines
Submission Deliverables
A complete list of deliverables can be viewed in the TopCoder Assembly competition Tutorial at: http://apps.topcoder.com/wiki/display/tc/Assembly+Competition+Tutorials
Below is an overview of the deliverables:
- Updated application that works with SQLite
- A complete and detailed deployment documented explaining how to deploy the application including configuration information.
- Database scripts to populate test data
Final Submission
For each member, the final submission should be uploaded via the challenge detail page on topcoder.com