SQL Server 2000 detailed steps for importing a database to oracle

1. Open the SQL Server Enterprise Manager and choose database> all tasks> export data;

2. Select a Data source:

[Data Source] Select "Microsoft ole db provider for SQL Server", which should be the default value.
[Server] select the server for which you want to export data. If it is a local server, select (local)
[Database] select the database where the data to be exported is located. Select DXJKSJK

3. Purpose:

Objective] To select Microsoft ODBC for Oracle
[DSN] select the user/system DSN item, and then find a DSN name that has been connected to the user in the drop-down list box.
    If no data source exists in the drop-down list, click [new] on the right of the drop-down list. The create Data Source Page is displayed.
    Next, select the system data source. Next, select Microsoft ODBC for Oracle from the driver list.
    Next, complete. The installation page for Microsoft ODBC for Oracle appears.
    [Data source name] enter the name as needed, such as sss
    [Description] Not Required
    [User name] fill in the name of the Oracle user to be exported. Here is Data (you can create a corresponding user in the Enterprise Manager Console and grant the corresponding permissions)
    [Server] fill in the service name used to connect to the Oracle server. For example, if sqlplus scott/tiger @ myoracle can be used to connect to the database, enter myoracle here. If the machine is a server, use sqlplus data/data to connect to the database. leave it blank. A server is the name used to create a Database. For example, when Oracle is installed, myoracle is the server by default. You can use Database Configuration Assistant to create, modify, and delete your own Database.
     In this way, a data source sss is created to ensure that sss is selected in the drop-down list box.
[User name] fill in the name of the Oracle user to be exported. Here is data
[Password] fill in the password used by the Oracle user to export to. Here is data

4,Next, specify table replication or query
If you want to export the entire table, select [Copy table and view from source database]
If the content to be exported is a part of the table's columns, you can select [use a query to specify the data to be transmitted]. In this case, you need to write a query statement.
Select the first item [Copy tables and views from the source database].

5,Next, select the source table and view
Click the check box of the Products row in the table to be exported. The content appears in the "purpose" and "Conversion" columns.
The purpose is to select a table name. Conversion can be used to modify the column data type or the SQL statement used to create the entire table

6,Next, save, schedule, and copy packages.
Select Run now

 

7,Next, the DTS import/export wizard is being completed, prompting "copying n tables from Microsoft SQL Server to Oracle succeeded". Close the Import and Export program.

Note: sometimes some tables may fail to be imported. The reason should be taken into consideration, probably because of the order of imported data, because each table is constrained,

In any case, you should re-import the table data that has not been successfully imported. Until all data is imported ~~~

Turn: http://ghtmy003.blog.163.com/blog/static/35739266201063033130658/