Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
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, 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.
Freelancer.com (formerly GetAFreelancer, Scriptlance and vWorker/Rentacoder) is the world's largest freelancing, outsourcing and crowdsourcing marketplace for small business. Hire freelancers to work in software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services.
Find freelance jobs and make money online! We have freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, custom programming, professional writing or affordable marketing has never been easier!
© Copyright 2013 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)