What version / flavour of RH are you using?
You talk about a production database, but do you mean a production (web) server?
yes, I think I mean a production web server.Basically I copy my webhelp folder and paste it onto my company's server so that the employees can view the web help file.
My output in RH is not showing on the server. My TOC looks different on the server then it does in the RH output.
We are experiencing the same issue. Normally, after making updates to the various chapters/pages, we FTP the appropriate generated html file to our web server. These items are updated successfully onto our website. However, our latest issue is that after renaming an item in the Table of Contents, we don't know which RH8 file (hhc, html, etc) to upload to our web server so that our changes our live on the Internet.
When you regenerate the help there are many "internal" files that need to get updated. Using RoboHelp's publishing feature ensures that all the necessary files get uploaded to the server.
If you want to stick with FTP, when you generate all the files are recreated so you will have difficulty in identifying which ones have changes. You could publish locally and then you would be able see what has changed by looking at the file dates.
As you have found, FTP is problematic if you only want to upload what has changed. HHC and other such files will only be found in the source. The contents are split in many files in the output.
See www.grainge.org for RoboHelp and Authoring tips
Just copy the whole thing up again & replace it all - why bother hunting for changed files only when you're not finding them quickly?