Project Description:
Create a .NET program capable of running on any windows operating system that will read files from a predefined folder structure and install them on an SQL 2000,2005, or 2008 database.
The application has 3 tabs, Client,Utility and Database.
Client Tab:
Has prompt for 1 file paths. Files from a folder compiled into the application will be installed to this location. Just a simple copy of files to this path.
Utility Tab:
Has prompt for 3 file paths. Files from 3 folders compiled into the application will be installed each this location. Just a simple copy of files to this path.
Database Tab:
The Database tab allows the user to specify 3 sets of connection information to install scripts against (SQL Username,SQL Password, Server, Database). There is a button to allow the user to Test the connection to be sure the login works and our app can successfully connect.
*All File Paths Default from Registry Keys
The .NET executable must be able to compile folders into it.
For example in my project I might have a folder called "App", with sub folders for each type of database objects:
Tables
Stored Procedures
Views
Functions
Inside those folders are individual scripts for each type of objects. So if I need to install 3 tables, the Tables folder would have 3 scripts in it, Table1.sql, Table2.sql,Table3.sql and they would need to be Executed if the user Checks "Tables". See screenshot
Then when the user selects to install App objects it would run the scripts on the "App Database" defined in the Database Tab.
.NET, C# Programming, SQL Additional Files: NewForecasting_Installer.pdf
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.
