Hi Madhu,
Firstly, when using SQL Server Migration Assistant(SSMA) to migrate Oracle database to SQL Server, the account used to connect to the Oracle database must have at least CONNECT permissions. This enables SSMA to obtain metadata from schemas owned by the connecting
user. To obtain metadata for objects in other schemas and then convert objects in those schemas, the account must have these permissions: CREATE ANY PROCEDURE, EXECUTE ANY PROCEDURE, SELECT ANY TABLE, SELECT ANY SEQUENCE, CREATE ANY TYPE,CREATE ANY TRIGGER.
Refer to:
https://msdn.microsoft.com/en-us/library/hh313203(v=sql.110).aspx .
Secondly, please download the latest version:
Microsoft SQL Server Migration Assistant v6.0 for Oracle and use it to migrate Oracle database. SSMA helps speed the entire process by automating almost every aspect of database migration, including database assessment, schema and application migration,
data migration, and validation of the migrated database. For more detailed steps about how to migrate huge database from Oracle to SQL Server, please
review this
guide.
For more details about how SSMA speeds up and reduces the cost of migration at every step, please review this
article.
Thanks,
Lydia Zhang
Lydia Zhang
TechNet Community Support
