Aqua data studio export database

Question

How can I export a database from MS SQL to Oracle? Is it possible?

I create a ER schema in MS SQL then try to convert and generate script. I just need to run it in the Oracle window?

CREATE TABLE "dbo"."Categories"  ( 
    "num_categories"    NUMBER(38) NOT NULL,
    "descriptions"      CHAR(10) NULL,
    CONSTRAINT "PK_Categories" PRIMARY KEY("num_categories")
    NOT DEFERRABLE
     NOVALIDATE
)

also export a inserts

Asanali Isataev
– Asanali Isataev

2016-10-17 14:44:24 +00:00
Commented Oct 17, 2016 at 14:44 — Asanali Isataev
– Asanali Isataev, Commented Oct 17, 2016 at 14:44
Can't you use a DSN to connect to Oracle from SQL?

SS_DBA
– SS_DBA

2016-10-17 15:54:09 +00:00
Commented Oct 17, 2016 at 15:54 — SS_DBA
– SS_DBA, Commented Oct 17, 2016 at 15:54

tariq · Accepted Answer · 2016-10-18 15:41:59Z

Right click on the Database, Go to Tools > ER Diagram Generator, select the Schema, Objects in your source DB and create the ER Model.
In the ER Model window, click on Tools > Convert Model and select the Destination Database (Oracle in your case)
Make the necessary changes in the Columns and make sure the Datatypes are correct and can be mapped
Click on Tools > Generate Script and select all Object Types. In this step scripts for Tables, Views and Indexes will be created.
Next, open a Query Analyzer window to Oracle and paste the script that you generated in Step 4.
Execute the script in Oracle. Now you have similar scripts as in your Source DB.
Navigate to Source DB, select each of the tables, and Export to Excel.
Navigate to Destination DB, select the table and Import from Excel.

Links https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation17/page/76/Generating-ER-Diagrams https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation17/page/74/How-to-Import-Data

Collectives™ on Stack Overflow

Aqua data studio export database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related