Ask the Expert

How to dump SQL Server database with Oracle data

We need to dump a SQL Server 2005 database with the data from an OLTP Oracle 7.2.3 database daily. Which of the following is better:
  1. Pulling data from SQL Server 2005 DB
  2. Pushing data from Oracle 7.2.3

    Requires Free Membership to View

From experience, I would pull data from SQL Server using DTS packages. With this all you should need to do is configure an ODBC connection to the Oracle database.

This was first published in June 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

Forgot Password?

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

Your password has been sent to: