Oracle - SQL Server 1

[vijuvelu]

Can anyone help me in learning how to load a table in SQL Server with the data in a table in Oracle? How do you connect to SQL Server from Oracle?

 

[foxdev]

The simplest and easiest method (if it works ;-) ) is to use DTS - Data Transformation Services. You can find a shortcut to the Import Wizard by clicking on:

Start/Programs/Microsoft SQL Server 7/Import and Export Data

You can also access DTS from the SQL Server Enterprise Manager.



Robert Bradley

http://www.foxdev.com/

 

[vijuvelu]

Thank you Robert! I am sorry my question doesn't give the full picture.
I work on Oracle and I need to log on to a remote SQL Server to load a table there with the data in my table. I have the IP address and the username/password for the remote SQL Server.
Thanks

 

[foxdev]

If you have administrator privileges on the SQL Server, then you can still perform the import from Oracle - either just once, or save the generated DTS package and run it multiple times, even schedule it.

If this won't work for you, then you could export the Oracle data as a text file, then use SQL Server's BCP utility or its Bulk Insert command. BCP is probably the most commonly used, and can be invoked from the NT command line.

Robert Bradley

http://www.foxdev.com/

 

[vijuvelu]

Thank you for your prompt replies. I will try this and reply back.

Viju.

 

[Nanda]

Robert, VLakshmi,

I need to deploy my Oracle database to SQL server database. Will the import form Oracle/BCP do in one step....else what all is involved?

Thank you

 

[foxdev]

Nanda, I would try the Import Wizard first and see if that doesn't do everything you need it to do.

To use BCP, you'll first have to export it from Oracle; figure out the format; then import it into SQLS.

Robert Bradley

http://www.foxdev.com/

 

[calahans]

Hi Nanda,

I have used the Import wizard mentioned. All you need to do is to create an entry in the tnsnames.ora file, so you can connect to Oracle. Then create an ODBC link to the Oracle database,using the entry and follow the step by step screens of the wizard.

Actually we used the SQL Server Import wizard to upload the tables & data from an Access database to an Oracle database we had running. Gotta love that utility!!!!

Cal