![]() datastudio directory to an external storage device. The user may easily backup all application customizations and server registrations by copying the full contents of the. Windows Vista, Windows 7 and Windows 8.1 = C:\Users\USER_HOME\.datastudio Windows XP = C:\Documents and Settings\USER_HOME\.datastudio is the home directory of the current user logged into the Operating System. Migrating Aqua Data Studio from one computer to another computerĪpplication Customizations and Server RegistrationsĪqua Data Studio stores all application customizations and server registrations in the \.datastudio directory.To copy Server Registrations from one machine to another machine.Troubleshooting Missing Connections on Windows.Database and SSH Server Connection Configurations.Application Customizations and Server Registrations.The locations of these files vary based on the Operating System. It is possible to transfer all or some of the files which are used for database server and SSH server registrations to another user or another computer. You can generate HTML reports from models, which include HTML navigation elements and detailed information about database objects.Aqua Data Studio's settings, options, connection files and configurations are designed to be easily backed up, copied and modified. They may be printed across multiple pages. It is easy to set the dimensions of the printout to fit your needs. Print ER Models and Generate HTML ReportsĮR Models can be printed for quick reference. Save as ImageĮR Models can be saved as a JPG or PNG image for inclusion in word processing documents or presentation slides. The DDL of one database can be converted to the DDL of another database through the use of the “Convert to…” tool to ease migration 4 from one database vendor to another. The script can be executed in a Query Analyzer window to populate a database with objects. Forward EngineerĪn ER diagram can be quickly converted into a DDL 3 script using Tools->Generate Script. You can adjust the “zoom” of the model with the mouse scroll wheel. 1:1 Scale, Zoom In, Zoom Out, Fit to Window are the different views available. The ER Modeler has a rich set of features for choosing model views and built-in sheet layouts, which make your data visualization much easier. Sheets are views of the model and multiple sheets can be added to a diagram. Properties for a selected entity are displayed in the Object Properties pane at the bottom of the window. Comments appear at the bottom of table entities. To add a table, click on the Table Entity in the Palette and then drag within the sheet to create it. The ER Modeler supports Information Engineering (IE) notation. Developers in an organization can access ER Models associated with a version control repository, modify and track their changes. Version Control IntegrationĪqua Data Studio provides integration with several version control systems like CVS, Subversion (SVN), Git and Perforce. Use Ctrl-G to quickly locate and identify database entities in the ER Model. The DDL script for each object is shown and differences are highlighted in a graphical and text notation. It allows comparing two ER models, or an ER model to an existing database. The ER modeler is integrated with the Aqua Data Studio Schema Compare Tool. Import DatabaseĪ powerful and flexible feature of the ER Modeler is the Import support under Tools-> Import Database, which allows you to add tables and views from existing databases into your model. Reverse EngineerĪn ER diagram can be extracted from an existing database (commonly referred to as reverse engineering 2 ) and its schema objects displayed as a model by using Tools->ER Diagram Generator in the Server Browser. An option for Schema Folder Grouping is also available. Use the Display options to model diagrams based on Attribute, Primary Key, Entity, Physical Schema, Nullable Columns, Comments or Relationship Names. You may then move Regions around, to move a group of objects. To make a region, drag one around the objects you wish to group. Regions are used to group displayed objects in a sheet. Create a physical database model by dragging and dropping tables, indexes, constraints, relationships, notes and regions from the Palette. A graphic display 1 of database objects can be created manually by adding entities on a sheet and altering their attributes. The ER Modeler allows you to create professional database designs with its rich set of features.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |