import Oracle table to SQL server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

import Oracle table to SQL server

Author

Topic

26SQLserver
Starting Member

3 Posts

Posted - 2010-06-21 : 09:53:29

Hi all,

i need to import a oracle table's data to sql server table. we have alreday same structure table in SQL Server database onyl we need data of the oracle table .

i tried throught the following way

Databases ---> <databasename> right click and select Task
then import table.......

please give me step by step or show me the link to import table's data

Quick response will be higly appreciated.

BEST REGARDS
hussain

BogeyGrinder
Starting Member

6 Posts

Posted - 2010-06-21 : 15:51:01

Have you tried installing the Oracle ODBC drivers and then repeating the "Import Data" wizard in SQL Server? That will allow you to choose and establish a connection to Oracle.

Oracle ODBC drivers are available here:
http://www.oracle.com/technology/software/tech/windows/odbc/index.html

26SQLserver
Starting Member

3 Posts

Posted - 2010-06-22 : 01:22:22

quote:
Originally posted by BogeyGrinder

Have you tried installing the Oracle ODBC drivers and then repeating the "Import Data" wizard in SQL Server? That will allow you to choose and establish a connection to Oracle.

Oracle ODBC drivers are available here:
http://www.oracle.com/technology/software/tech/windows/odbc/index.html

Dear ,

yes i have already configure ODBC and all these thing i just want import ORACLE TABLE' DATA TO sQL SERVER DATABASE

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources