Show Bid Request ASP Paradox Upload to SQL Application Bid Request Id: 1430 Bookmark in my 'To Do' list Posted by: PCU (28 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 18.52% Buyer Security Verifications: Good Approved on: Aug 6, 2001 11:42:43 AM EDT Bidding Closes: Aug 20, 2001 11:42:43 AM EDT Viewed (by coders): 647 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Small Business Project: $100 (USD) + Bidding Type: Open Auction Categories: Web, Database, ASP Enter chat room for this bid request (0 active users at Aug 28, 2003 10:01:39 PM EDT) Description: We need an ASP utility that will upload 12 to 15 Paradox ( versions 5 and 8) databases into an MS SQL database. If you can't do it don't bid. Deliverables: This utility will be run between 2 to 4 times per year. It must be written in ASP and use stored procedures in the SQL database to keep the resources on the client machine Free. The utility must show a progress bar or record count as it steps through the records and give a total at the end. The utility must also allow the user to select the database to Import. about 5 or 6 databases will be completely replacing the current SQL database and the other will Update or add records. There has to be a method to keep track of what records from a database has been updated to added incase the operation did not complete and the user can pick up where it was left off. Also we need a single script or stored procedure that will remove Duplicates records in the SQL database working with 5 different tables. Special Conditions / Other: 7 days to complete 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   This bid was accepted by the buyer! Brian (3 ratings) in Fredericton, New Brunswick Canada Bid id: 12,850   $350 (USD) Aug 7, 2001 7:59:21 AM EDT  10 (Excellent)     This is not an incredibly difficult task. It can be handled using a variety of methods, all of which involve uploading a copy of the paradox file to the server and working with it from there. At that point a stored procedure on the SQL server can trigger an import function (SQL Server 7 can import data from Paradox 5.X and possibly from 8), or ASP can simply access the paradox data then connect to SQL Server and place the data there. I rather favour the second approach as it is most flexible, allowing the source and the destination to be easily changed. It does take more server resources, but this is not a daily process. I am a professional programmer with over 7 years of experience. I have even designed and taught a 10 month course entitled <span style='color:blue'>Database & Internet Programmer</span>. I know that you will be pleased with the speed and utility of my work.