Around 3 years ago we have made a software with the help of a freelancer from Elance. The purpose of the software was to track sales docs (Invoices, Quotes, DO's, etc etc) for a furniture company. These would be organized per client, and would have all the information of the client, and all the sales docs under him which are serialized. There would also be a product list which is enrolled in the software, and allows for easy product placement into the docs. Finally, the docs get exported as .Doc files (we have the working templates with strings to pull data from the software). The original developer is currently unavailable to assist us with this.
The software is using SQL express 2012 for the Database and LightSwitch for the front end. Now, what has happened is that recently the server on which this was installed had crashed. We had backups, but we could not restore them. We have reinstalled the OS, and made the SQL express ready. We have backups of the SQL folders from before, and we had tried to import these database files. They turned out to be unusable as they were not .BAK format. Another person who works with SQL assisted us and manually fixed the database and turned it into a .BAK file, which worked. But another issue arose is that the software had stopped functioning in the following ways :
Unable to make new documents, Cannot save the document nor add products to it. Same error for both.
Database seems to have duplicate serials.
Some data is also lost, but if this cannot be recovered then this is fine.
What we require : To repair the software and get it to a state where it functions exactly as before. And to assist us with creating a fail safe to prevent this sort of problem from happening again (can be with the simple procedure of proper backup or something else).
The budget can be negotiated, but we need results and fast. What we have :
Chat records with original DEV. May contain information to assist with fixing this or knowing how the software works.
Installation packages of various versions of the software.
Access to the client's server and the SQL database.
We do NOT have :
Original Developer source files.
We look forward to your bids.