I need an ASP.NET WebForms application built (C#) which uses MS SQL SMO, TSQL, and other methods to do several things.
1) Update a test SQL Server database by restoring the latest production backup of the same database to it. User will be able to choose from all the available databases on the production server to update onto the test server.
2) Update a test, dev, or production SQL Server database schema by comparing it with another.
3) View SQL Server Jobs on a given SQL Server as well as their schedule, steps, history, last execution result, and have the ability to manually run them.