I came to similar issue while supporting German database from Australia. We have repeating town information in German and in English: like one row in English = "Grassing" and...
I created similar system for DB2 on AS400 copying data to SQL server every day, so we have 24 hours for regular reports and some "live" reports talking directly to...