through oracle10g Access SQL Server 2008 guided data steps
Recently encountered in a project to import data from an Oracle database into a SQL Server database, the workaround is as follows:
First, the preparatory work
Configure the Oracle client (TNS listener ) Tnsnames.ora file, which requires attention to the database alias "oradb" in the file, ensuring that the host can SQLPlus access to the remote Oracle database. Examples are as follows:
oradb=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST =hostip) (PORT = 1521))
(Connect_data = (SID =dbname))
)
Note:
SQL Server In the installation process need to be aware that the installation of the main files and shared files are not in (x86) (the solution is to copy them directly and then install, not the default )
Ii. start of data (using TNS method)
After the database is installed, click Import and Export data in SQL Server, point next, select the data source to export (the exported source is the TNS name, ORCL, etc.), the server name is
IP Address, select the data source to import, start the data import, and then select the imported data source (import address input destination SQL Server parameter), Start the import, you may encounter editing mapping problems (mainly different problems such as data types between SQL Server and Oracle , need to be manually changed), and then start to export data, then quietly waiting for the data to be finished.
Select a data source to export and select the data source picture to import as follows:
Select the data source graph to export:
Select the data source graph to import:
Summary of Oracle-guided data to SQL Server methods