Migrate / Copy Huge data from Oracle to SQL Server?

Question

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this process. But it takes a day for this process and takes too much time. Is there any better way? Any good outcome or step (SSIS, Any other functional step) to follow for this process?

Answer 1

BCP would be a good choice. Export your data to a text file and then import it.

Use below steps :-

1. Create your new table in sql server
2. Insert 1 row of data into this new table
3. Use BCP to get an export from this table containing this 1 row This is necessary so that you can create an export from Oracle that matches this
4. Generate an output file from Oracle that matches the format of yourtable.dat
5. Use bcp again to load the data file that was created by oracle into sql server.