• Bonus Prize to Hugo !

    That is a brilliant consideration, and one that in theory I should spend a lot more time researching.

    I have to admit, I know little about how they work.

    There is a lot of relational data in my Database, as well as the less relational 'text' issue I exposed in the main post.

    I'd be interested to look at NoSQLs and find out how the balance would work.

    Unfortunately, whilst that all might go toward a long term final solution, the immediate term is a lot simpler.

    I simply do not have access to anything but MS SQL.

    And to adopt a new product, in my corporate environment; well you might see something in 2 or 3 years if lucky.

    But thanks for the response.

    I'm going to be sure to add that to my report and flag it for awareness going forward.