I need to clean up the results of a premature move to production of a small application I built. Due to a few minor logical errors and an overly aggressive timeline, the errors didn't become apparent until the application was put fully into production, and so on.
The application parses medical transcription files for insertion of records into a SQL Server DB and storage on a File Server.
I need to accomplish the following tasks.
1. A number of records have been inserted into the database without the corresponding files being moved into the storage directory. When accessed in the final product, they appear normal until loaded and then error out. The files are stored and referenced as GUID.doc or GUID.rtf.
I need to be able to search the file server and return the database records that are orphaned from files.
2. A number of files have been moved into the storage directory, without the requisite records being inserted into the DB, or with erroneous records inserted.
I have cleaned up the erroneous records, and now need to address the orphaned files in the storage directory. The files need to be archived to a backup directory for possible manual review.
With any luck in the end the DB and Storage will be in sync and all will be happy.
I am proficient in SQL inside of the DB but have never addressed files at the storage level via SQL and have next to no idea how to proceed.
Any and all help is appreciated. Thanks in advance for the energy expended.
I have not read the full Posting Rules, and presume it is inappropriate to offer payment for services. On the chance I am wrong; I have no issues with paying someone for their time.