Challenge Overview
Competition Overview
Detailed Requirements
In previous challenges, we have enhanced the app with new admin features, and because of that we had to make changes to the database structure. However, we already have the previous version (without admin features) in production, and we need to develop a sql script or a c# program to upgrade the database from the previous version to the latest version (the admin features version) without losing any production data. This basically means we need to alter the existing database intead of dropping all tables and recreating them.
The purpose of this challenge is to develop such a script or program. The target database is SQL Server 2012.
Additional Notes
- Please make sure no exisitng unit tests are broken after this challenge.
- Please make sure no existing features are broken after this challenge.
Technology Overview
Visual Studio 2015SQL Server 2012
Windows Server / Azure
Active Directory
C# / .NET
REST
Angular.js
HTML5
Javascript
RESTful services
Final Submission Guidelines
Submission Deliverables
1. SQL Script or program to perform the database upgrade.
2. SQL Script to setup test data for the original version database, so that we can run the upgrade script and verify that no data is lost.
3. A readme with verification details for your submission.
Final Submission
For each member, the final submission should be uploaded via the challenge detail page on topcoder.com.