Moving data between sql server database and oracle database when the databases have different table structures!?
Posted on 2008-10-23
i'm wondering if there's a tool to move data from a SQL server databse to an oracle database taking in consideration that the two databases are diferent in structure, but eventually must contain the same data, like for example i have a table in SQL server that holds all customer profile information, this same table is split into 3 tables in oracle database and i need to populate those tables with the data from the sql server table, its a it complicated and i'm searching now for the best way to do that, so your help is highly appreciated!!