Am evaluating Aqua Data Studio 14 and have a question about data definition import capabilities.
As a consultant, I am often unable to connect to the customer’s domain and need the ability to import a definition from an external file. It appears the only option in Aqua Data Studio is to use Import Database and establish a connection to a database. Is there another way to import (e.g. via DDL parsing in ERwin) or via a uniquely organized/formatted file (e.g. Excel worksheet) to import definitions into Aqua Data Studio? Or is the only option for me to externally format an XML file according to the usage rules of Aqua Data Studio?
Tariq Rahiman over 9 years ago
With Aqua Data Studio, you can create an ER Model
1. By connecting to a DB Server and using Tools -> ER Diagram Generator
2. Creating a new model from scratch using ER Modeler -> New -> DB Version
3. Importing a Database Schema into an existing ER Model.
>> Is there another way to import (e.g. via DDL parsing in ERwin) >>
The ER Modeler currently doesn’t have the capability to perform DDL parsing.
>> Or is the only option for me to externally format an XML file according to the usage rules of Aqua Data Studio? >>
You can save an ER Model and it will be saved in an XML format with an .xed extension. To manually make the changes would not be a feasible solution.
You can use Tools-> Convert Model.
If you have the Customers SQL file containing the Database Objects, you can create the objects in your local machine by making changes in the script and executing the script in MySQL or PostgreSQL.
Connect to the server, right click in the tree and use Tools -> ER Diagram Generator to create the ER Model.
From the model, use the Tools-> Convert Model feature of Aqua Data Studio to convert to the RDBMS of your choice.
The datatypes gets mapped automatically.