On 16/07/13 01:39, Hona, David wrote: > Regardless of the toolset, the first hurdle would be to normalise your > database to look like a relational one. Which is likely to be the greatest > hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting > purposes - they can have duplicates and these can be conflicting. Even worse > (as if you thought it could be) - data dictionaries can be incomplete or > wrong. This added to the lack of enforcement of data integrity and > constraints usually causes these toolsets to fail (indeed, even the UV/ODBC > driver fails too!)... so good luck! > > Rocket released U2 Metadata Manager to assist in this respect and is designed > to allow forward and backwards capability. Although, support for this in UV > is limited to the latest official release... so your alternative is UV/ODBC... > > For UV/ODBC users - I have always recommended a separate UV account and data > dictionary that is spotless. For some this is the best option - why go > against the flow - when you create your own stream...
And look on Pickwiki - there are a few tools there meant to clean up dictionaries ready for ODBC export. The problem is when there's loads of data of the wrong type in your field ... :-) What do you do when you need to clean the data file, as well as the dict ... Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users