I don't know if that's the easiest approach. That would entail creating a 600 gig relational database and another step to populate it from the 50 odd client databases.

I would prefer cutting that step out if possible.