We have RDBMS that stores data in a normalized format .
1) What is the best format for import export from one DB to another assuming it might have binary data too ? Perhaps XML would be good ? XLS has 2 draw backs of each cell restricted to 32K and Binary Data not suited for XLS .
2) Are there any cool tools out there that understand foreign keys and handles them intelligently ? That is , it exports the foreign key row and maintains the relationship .
Ofcourse Primary IDN's are no longer relevant in new system - can be dropped from the base table . If there are tools that can preserve the Foreign Key row ( perhaps recursively if there are child primary idns and no circular reference ) that would be something that I want . Let me rephrase the quesion : How to import export partial tables maitaining their RELATION in Relational Databases like Oracle and SQL ? Further the format should be XML or something standard .A sort of Deep Copy of the data from tables would be an appropriate description of the task
How Do I Deep Copy a Set of Data, and Change FK References to Point to All the Copies? looks like a similar question .
Simple Table:
Student_IDN Name City_IDN
1 Frank 5
2 Mark 7
City_IDN City_Name City_Description City_Additional_Info
5 London England Country Visa....
7 Newwark USA Europe Visa