I'm trying to find an easy way to do the following. 1. import a data set into the database (e.g. from XML to PostgreSQL) 2. export a data set from the database (e.g. from PostgreSQL to XML) 3. transform the schema of a data set 3.1. rename columns/properties 3.2. convert a flat file into several related tables. Essentially, this would normalize the data before import.
I know that Torque can export data with the datadump task and import with the combination of the datasql and insert-sql tasks. However, I haven't seen a solution to the transformation need. Unless a solution already exists, I'm interested in adding this functionality to Torque or whatever makes sense. Commons anyone? I would greatly appreciate any feedback, ideas, etc. Eric -- Eric Emminger [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
