Geek Answers Handbook

Copying 6000 tables and data from sqlserver to oracle ==> the fastest method?

I need to copy tables and data (about 5 years of data, 6200 tables) stored in sqlserver, I use datastage and odbc connection to connect, and datstage automatically creates a table with data, but it takes 2-3 hours per second, the table is like tables very large (0.5 gigabytes, 300 + columns and about 400 thousand rows).

How can I achieve this, since at this rate I can only copy 5 tables per day, but within 30 days I need to navigate these 6,000 tables.

+5
source share
3 answers

6000 0,5 3 . . , , ODBC, , .

SQL Server. SQL Server Oracle. .

, , , , , , , . Oracle - ( ), .

, . , , , .

+6

?

SQL Server, - SQL Server, , .

+2

Have you thought about writing table schemas and creating them in Oracle, and then using SSIS to bulk copy data to Oracle? Another alternative would be to use linked servers and a series of "Select * INTO xxx" statements that will copy the schema and data (minus the key constants), but I think the performance will be very miserable with 6,000 tables.

+2
source

More articles:


All Articles