Shulou(Shulou.com)05/31 Report--

This article mainly introduces a case of rapid migration of a large data table in Oracle to Sqlserver2008 database, which is very detailed and has a certain reference value. Interested friends must finish reading it!

Oracle Server version 11.2.0.1.0

Sqlserver2008 R2

The prerequisite is that the Oracle client is installed and configured on the SQLSERVER server

1 Log in to the MSSM tool

2 Select one of the databases

Right-click ⇒ task ⇒ to import data

3 Open window Sqlserver Import and Export Wizard Click next

4 enter the screen of selecting data source

A: data source selection Microsoft OLE DB Provider for Oracle

Then click the properties button on the right

5 data link properties window pops up

A: enter the server name (this name is not the IP address of the Oracle server is the service name when you set up the listening when installing the Oracle client, that is, the alias in the tnsnames.ora file)

Enter ORCL here

B: enter the login database information (that is, the user name and password to access the ORacle server)

C: then click the test connection

6 Click the OK button and click next.

The server name is SqlServer2008 server IP

Authentication choose to use Sqlserver authentication

User name and password enter the user name and password of the server

Database Select the object database for importing data from Oracle server tables

7 Click next when the input is complete

Select the default to copy one or more tables or attempted data

8 Click next to select the source table and source view window

Select the table to be exported to the right is the name after importing the Sqlserver database double-click to change the user name and table name

Here, take the table Oracle [APEX_030200]. [WWV _ FLOWS] as an example and import Sqlserver to dbo. A

⇒

9 Click next

10 Click the next step

11 Click next and then click finish to migrate the data

12 the following figure appears after a successful migration

The result of your own migration is

The migration time of 1 million messages is 2 minutes.

Both servers are on the same local area network

These are all the contents of this article entitled "the case of quickly migrating a large data table in Oracle to a Sqlserver2008 database". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.