Login Form






Lost Password?
No account yet? Register
Freelancer Jobs arrow Freelancer Jobs - Archive 2007
JobId: #1270480

SQLServer data extraction applet

Categories: Microsoft Windows,Language Specific,Operating Systems / Platforms,C#,Visual Basic .Net,SQL Server,Software Related (Includes Websites)
Posted By: ismcoh  (0 ratings)
Source: Rent-a-coder
Job viewed: 296 times
Bids Placed: 11
Start Date: 2009-10-13 13:39:27
End Date: 2009-10-27 12:56:54
Time Remaining:
Deadline: Please estimate in your bid
Current Phase: Bidding open
Max Accepted Bid: Open to fair suggestions
Project Type: Medium Business Project: $500(USD) and above
Bid Type: Open Auction
Brief Summary:

The intent of this Win32 'desktop'tool is to assist our clients in extracting result-set out of a specific database (SQLServer-based) belonging to a specific Network Management Tool, such as Microsoft’s SMS & SCCM. **NOTE: There is no requirement to deploy or be knowledgable with Microsoft SCCM/SMS ** Each result-set (only one at this moment) requires invoking a SQL Query against the database. The Data extraction tool will require the end-user to: a)Declare which network management tool they will connect to b) Identify-and attach to – that applications’ database located on the customer’s ‘network’. c)Store the type of application and path to database for future usage d)Choose which datasets they want to create (selection to be stored for future reference) e)xecute the required SQL Queries (based upon ‘tool’ & dataset chosen) f)Save each dataset as a MS Excel (97) XLS file on the end-users desktop (other other location) The data extraction tool must: Be written for a Win32 environment, and work in Windows XP & above, as well as WinServer 2000 & above. Allow for any and authentication requirements (logging into the database, for example). Allow for the update of new SQL queries based upon supporting a new Network Management tool for result-set ‘X’, and/or to create a new set of SQL queries to generate a new result-set ‘Y’