Show Bid Request
Visual Basic program that will compare the data from two different databases, and write a detailed error report when program finds values that didn't match while doing the comparison. Please see below for program specs
Bid Request Id: 4161
|
|
|
Description:
Visual Basic program that will compare the data from two different databases, and write a detailed error report when program finds values that didn't match while doing the comparison. Please see below for program specs
Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
Main screen should have a button for a connection to database #1, a button for a connection to database #2, A button that says "compare databases", and a button which allows the user to view the error report. The error report should be exportable into Excel format also.
As far as the database connections are concerned. Connection should be done through the data environment. Whenever the user hits the button to load the connection to the database, the "Data Link Properties" page should appear to let the user select a provider, and a connection. The user should also get to choose command properties for that connection. I.e, the dialog box that allows the user to select a database object, which has the drop down menu of (Stored Procedure, table, view, Synonym)
Assumptions: Tables being compared DO HAVE the same number of columns. However, the headings in database #2 can only be max 10 characters, while headings in database #1 can be longer than 10. For example, if a column in database #1 is FEATURE_DESC, then that column in database #2 is FEATURE_DE.
Data being compared is not necessairly in the same order in both of the tables. For example, if FEATURE_DESC is the first item in database #1, it may be the 10th, 11th, or 40th, etc.. item in database #2. Databases can be different formats also. i.e) first database is oracle, 2nd database is Access. Etc... The user should also get to choose what the "unique" field of the tables that they will be comparing.
I know this sounds real complicated, but I hope there is someone out there who gets it.
Error report should print out the data that did not match, including column headings. The first column heading should be the "Unique" field that the user chose before.
Special Conditions / Other:
Due to some confusion, I have attached a file containing the screen shots that I am referring to when connecting to a database.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
|
$20 (USD)
|
Oct 27, 2001
1:54:50 AM EDT
|
9.1
(Superb)
|
|
|
hi there
your goods are ready to be delivered...
let me know ill send you the app...in case you want to have a look at it...
regards
Sandeep Nasa |
|
|
|
|
|
|
live RSS newsfeeds
Web Solutions Inc