Hello friends i had posted two questions for same issue and my friends helped me and i have gained some knowledge now I will discuss from the begining I have purely different schema on sql side so i do not want to move the schema. But i can't move the data even as i do not know in which table the data will go as the design on sql side is more normalized and there is no documentation here which tell me. So my first question is how should i figure out that relationship between the tables? second is i was thinking to use SSMA but its giving me some problems as i am using windows xp so no compatable so is it possible for me to use SSiS streight to do this? Please help me i know it seems weird putting same type of issue again and again Thanks in advancedimrd_SQL

You can use diagrams to figure the relationships out, however, if there are no foreign keys then that will not help. SSMA (migration assistant) may work for you as well as doing that with SSIS. Not sure how SSMA is not working on Win XP?Arthur My Blog

Arthurz thanks So acc to you SSIS can transfer the schema and data both from the oracle side. If yes then how should i start using SSIS. Please point me to a direction? Secondly I have joined new and there is no documentation on oracle side and any other that can help me to show some relationship. The tables in oracle are around 200 and in sql they are 400. The names are very different and sql design is very normalized? So also suggest me how should i find the relationship between the sql and oracle tables? Thanks dimrd_SQL

I think you need to read this - http://www.sql-server-performance.com/articles/dba/migrating_from_oracle_to_sql_server_p1.aspx It is how to migrate from Oracle to SQL Server.Arthur My Blog