SQL Server Migration Assistant for Oracle sample-Reprint

SQL Server Migration Assistant for Oracle sample (2012-03-12 16:23:24) reproduced

Tags:ssmaoraclesqlserverit

Category: System

Introduction:

Attempt to migrate Oracle 10GR2 data to SQL Server 2005 (or later).

Things to prepare for:

1). Oracle Enterprise Manager Console, Oracle Management client;

2). SSMA for Oracle 5.2.exe,sql Server Migration Assistant Main program installation package;

3). SSMA for Oracle 5.2 Extension Pack.exe, an expansion pack installed on the server where SQL Server is located, I tested the environment to install both the main program and the expansion pack on the same server as the SQL Server.

Official start:

1). First create an Oracle account for data migration (in this case, Ssma), I continue to lazy, directly give the administrator permissions, anyway, after the use of the directly deleted;

2). Ensure that the Oracle Management client on the SQL Server server Oracle Enterprise Manager Console can use the account you just created (SSMA) to connect to the Oracle server;

3). Start SQL Server migration Assistant for Oracle and create a new project;

4). Confirm the new project name, save path, SQL Server version information, this example is SQL Server 2005;

5). Connect to Oracle database;

6). Enter the Oracle database connection information, the connection mode is Oracle Management client (Oracle client Provider);

7). When the connection is successful, the relevant Oracle data information is displayed, in this case the data migration is "billingserver";

8). Create a report for "Billingserver" to assess issues that may be encountered during the migration process;

9). In the event of a warning, direct "continue";

10). The evaluation report shows all possible problems and gives the time required to fix the problem;

11). Create the target database in SQL Server with no table structure or data in the target database;

12). Connect the SQL Server database in SSMA;

13). Enter the SQL Server database connection information, this example is the local database, using Windows authentication method;

14). When the connection is successful, the target database information is displayed, this example is "billingserver";

15). Execute the "Convert Schema" in the "Oracle Metadata Explorer" window;

16). Execute "Synchronize with Database" in the SQL Server Metadata Explorer window;

17). Confirm the library structure information to be synchronized;

After the successful execution of the "Synchronize with Database", the target database structure in SQL Server will be generated;

19). Finally, execute "Migratedata" in the "Oracle Metadata Explorer" window to begin the formal migration;

). The "Output" window shows the progress of data migration in real time;

21). When the data migration is completed, the report will be displayed in detail when the migration is unsuccessful.

22). The final result of this example, there are some small problems, it seems that had to be handled by hand.

Share:

0

Like

0

Gift Pen

SQL Server Migration Assistant for Oracle sample-Reprint