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.
| Author |
Topic |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2011-05-19 : 10:12:44
|
| I need to import tables from an Oracle database to a SQL 2008 database I installed the oracle client tool on the server ODBC is working properly, but the import tool from an Oracle database gives the following message: ORA-12560 TNS protocol adapter error (Microsoft OLE DB provider fro ORACLE)can you help methanks |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-05-20 : 16:25:22
|
| You can use sql server import/export wizard.1. login to sql server (ssms)2. select database where you wan to import tables.3. right click on database, select task, select import data.4. After welcome screen, select data source (from drop down list select Microsoft OLE DB Provider for Oracle).5. Select properties.6. In server name enter Oracle Database Name.7. In username and password enter username,password.8. test connection, and click next.9. On destination server, select your destination server, authentication mode and db name.10. on next screen select copy data from one or more tables or view.11.Select tables you want to import in sql server from oracle.12. Select execute immediately.I hope that will help. |
 |
|
|
|
|
|
Importing from an Oracle database