Oracle 10g to SQL Server 2008

5 pts.
Tags:
Oracle 10g
Oracle 10g Database
SQL Server
SQL Server 2008
Unix
Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under 1 scheme we have 3 or 4 different client tables. We need to load for client1 only client 1 tables, client2 client2 tables. This is dependent upon the values in certain cols and it depends upon a join condition. In Oracle SQL Loader you can do that kind of loading. Is there a utility/tool that is available in SQL Server with which I can select only certain table rows by joining 3 tables and do a bulk load. I need to transfer the PK and nothing else. Data and PK. Thanks

Software/Hardware used:
Oracle 10g, Sql Server 2008 and Unix windows
ASKED: April 19, 2011  9:01 PM
UPDATED: May 2, 2011  11:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes, you can use SQL Server Integration Services to do this. The designer can be found in the start menu under “SQL Server Business Intelligence Development Studio” in the same folder that the SQL Server Management Studio can be found in.

You’ll want a data pump task and within it just a OLEDB source and destination. Set the source to be a SQL Statement and put your select statement in there.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following