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.
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.
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.
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:
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, [url removed, login to view], [url removed, login to view],[url removed, login to view] 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.
24 freelancere byder i gennemsnit $826 for dette job
I have 13 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT