locked
Oracle to SQL server Migration Assistant Questions RRS feed

  • Question

  • .       What are the required access privileges for oracle database user account on a Production database ? What is the risk involved by granting those privileges ?

    What are the steps involved in  the conversion process on huge database with many objects and huge Data ? Does the tool have any special settings which can speed up  the conversion process  ?


    Wednesday, April 20, 2016 2:18 PM

Answers

  • 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


    Thursday, April 21, 2016 3:08 AM