locked
Oracle to MSSQL RRS feed

  • Question

  • User-240513752 posted

    I have a project which has Db of oracle,

    what is the best way to redesign the oracle to MSSQL( excluding the data) only need db design.

    Saturday, November 11, 2017 10:11 AM

All replies

  • User347430248 posted

    Hi Khan_1,

    you can try to refer method below may help you.

    Converting Oracle Database Objects

    To convert Oracle database objects, you first select the objects that you want to convert, and then have SSMA perform the conversion. To view output messages during the conversion, on the View menu, select Output+

    To convert Oracle objects to SQL Server syntax  +

    1. In Oracle Metadata Explorer, expand the Oracle server, and then expand Schemas

    2. Select objects to convert: 

      • To convert all schemas, select the check box next to Schemas

      • To convert or omit a database, select the check box next to the schema name. 

      • To convert or omit a category of objects, expand a schema, and then select or clear the check box next to the category. 

      • To convert or omit individual objects, expand the category folder, and then select or clear the check box next to the object. 

    3. To convert all selected objects, right-click Schemas and select Convert Schema

      You can also convert individual objects or categories of objects by right-clicking the object or its parent folder, and then selecting Convert Schema

    Reference:

    Converting Oracle Schemas (OracleToSQL)

    Loading Converted Database Objects into SQL Server (OracleToSQL)

    Regards

    Deepak

    Monday, November 13, 2017 2:59 AM
  • User991499041 posted

    Hi Khan_1,

    I have a project which has Db of oracle,

    what is the best way to redesign the oracle to MSSQL( excluding the data) only need db design.

    SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server.

    By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server, and then migrate data to SQL Server.

    Note that you cannot migrate SYS and SYSTEM Oracle schemas.

    Please take a look at SQL Server Migration Assistant for Oracle (OracleToSQL).

    Regards,

    zxj

    Monday, November 13, 2017 3:06 AM