I have a database of articles that I need to incorporate into an existing article database.
The new database does not store the articles in exactly the same manner as the existing one - for example, the current database does not store the author resource box seperately to the article, the new one does, so the two fields will need to be merged.
As I do not want to add all the new content at one time I prefer a solution that offers me the ability to run an import script at a time of my choosing as opposed to paying somebody to do the work for me.
I prefer to provide the URL of the existing site and a sample of the database in private.
As an 'extra' I am seeking a search script that can handle up to 400,000 articles and provide output as an Rss feed based upon the search results.