MS SQL/Window Application

Two Window applications (in C#): backup SQL data for MSDE/2005 SQL Express and a wizard helping user to import SQL data. **1. Backup tool:** * Allowing a user to set backup frequency (days) and time. * In the designated folder, find all SQL files start with "pcsec". * Allow user to select a folder for storing backup files. Remember it for next time. * Automatically detach (Window Authentication) ONE SQL database each time, backup MDF and LDF files into a sub folder(database name_year_month_day ), then reconnect. Go over all databases. * If backup is overdue, pop up a window asking the user whether to back up the database now or delay for the next day. When backup is successful, set next backup schedule. ** 2. Import Wizard:** <!-- --> * Allow user to launch a help Wizard. * Page1: Connect to the database named "PCSecretary" using window authentication. * Page2: Inquire the "UserTable" table, disaply all data rows for datafields "UserID", "Email", "FrstName" and "LastName". Let users to select one of the UserIDs (a numerical number). * Page4: Backup the database files "pcsec[UserID].MDF" and "pcsec[UserID][login to view URL]" in the SQL designated folder. * Page 5: Let users to browse for a set of .MDF and .LDF files. Copy the selected two files to the SQL designated folder by the name of "pcsec[UserID].MDF" and "pcsec[UserID][login to view URL]" in the SQL designated folder. * Page 6: Show status: Attach selected database files to SQL server. * Page 6: Show status: Grant database access to the following permission to users: * * [computer name]\ASPNET * [computer name]\IUSR * [computer name]\IWAM * NT Authority\network service ## Deliverables Extra: Provide a SQL test case. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform MSDE2000, 2005 SQL Express, Window XP/Vista, .NET framework 1.1, 2.0.