SQL Server Migration Assistant for Oracle使用手迹

1．  安装Oracle，在Cpu2.0, ram512M上是可以跑的

2．  建立数据库, 可通过Configuration and Migration Tools\Database Configuration Assistant

3．  Enterprise Management: : http://:5500/em, 不同的数据库有不同的端口: 5500, 5501, http://:5600/isqlplus 可运行sqlplus

4．  以sys登录需要 sys as sysdba, 密码

5．  导入导出, exp, imp, expdp, impdp.

6．  SSMA 需要先连接source, target:

7．  Create linked server is

Server name:	SourceDB (by default)
Provider name:	Microsoft OLE DB Provider for Oracle or Oracle Provider for OLE DB
Service name:
User login:
User password:

We highly recommend that you enter Oracle Provider for OLE DB.

没有linked server接下来的步骤都不能做

8．  Recommended Workflow

1.   Install the SQL Server Migration Assistant.

2.   Connect to the Oracle Database.

3.   Connect to the SQL Server Database.

4.   Browse through database objects.

5.   Run an assessment report.

6.   Convert all the database objects after specifying conversion options.

7.   Save a workspace.

8.   Save a script with the converted objects, or use the Synchronize feature to save the tables into Microsoft SQL Server database.

9.   If you didn’t synchronize converted objects in the previous step, run the script against SQL Server to complete the installation of the converted database.

10.  Migrate the data.

 

Parameter	Value
SQL Server host:
SQL Server port (leave empty if default):	1433(by default)
SQL Server instance name (leave empty if default):
Target database:
Target schema:	dbo (by default)
User name:
Password:

 

Parameter	Value
Oracle server host:
Oracle server port:	1521 (by default)
Oracle SID: (from tnsnames.ora config file)	ref to db name
Username:
Password: