Chat now with support
Chat with Support

Toad Data Modeler 6.2 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Legal Information

Get started with Subversion

Features and Tools > Version Control > Subversion > Get started with Subversion

Toad Data Modeler offers you integration with a third party version control system - Apache™ Subversion®.

Note: If you are familiar with Apache Subversion, you can skip this topic and navigate to the Application Settings topic.

To configure Apache Subversion on your machine

  1. Download your preferred installation package. Here, the VisualSVN is the preferred package because it contains Server, Management Console and svn.exe.

  2. Install both VisualSVN Server and Management Console.

  1. Define a path to your SVN Server location, specify folder for your repository and select an authentication method.

  1. After the installation, run the Visual Server SVN Manager and create a new user.


  2. Create a new repository.


  3. Edit properties of your repositories and add the setup permissions for your newly created user.


  4. Next step: configure the Toad Data Modeler Application Settings.

Application Settings

Features and Tools > Version Control > Subversion > Application Settings

To configure settings for Version Control System in Toad Data Modeler

  1. Select Settings | Options | Version Control System.
  2. On the General tab, specify user name, password and Working Directory.
  3. On tab Subversion, define a path to folder with svn.exe file.

    To save some time, make your Visual Server SVN Manager active, select your repository, right-click it and select Copy URL to Clipboard.

    Then paste the content of your clipboard to the Server Path field.
  4. If you want to use Working folder for all your projects, select section Paths and define Path to Projects to the same folder as you specified in field Working Directory.

Project Settings

Features and Tools > Version Control > Subversion > Project Settings
  1. Before you create a new project (with Version Control System) in Toad Data Modeler, run Visual Server SVN Manager and add a new folder to your repository.

    In this example, the new folder E-commerce will be created.
  2. In Toad Data Modeler select File | New | Project.
  1. If you want to define folders manually, select Empty Project with Version Control System. (Toad Data Modeler project has a predefined structure. See Create new project for more information.)

  2. Define the project settings and to keep the configuration simple, use the recommended option - Project and Repository Structures are Identical.


  3. Finally, specify a path to the folder with svn.exe file and Server Path. To save time, select your folder in Visual SVN Server Manager, right-click it and select Copy URL to Clipboard.
  4. Paste the path to Server Path field in Toad Data Modeler Project Wizard.
  5. Important: Now you have to right-click your created project in the Application View and select Subversion | Check Out. This step is required!

Subversion Actions

Features and Tools > Version Control > Subversion > Subversion Actions

You can run Subversion actions from the Application View.

To add a new folder

  1. Right-click your project name and select New Folder. Create a new folder.
  2. Right-click the folder and select Subversion | Add.
  3. To commit changes right-click the folder again and select Subversion | Commit.

To add a new model to project

  1. Right-click the project name or folder name and select New Model.
  2. Right-click the model name and select Subversion | Add. Confirm it by Subversion | Commit.

Other Files in Project

You can add also *.doc, *.xls and other file formats to your projects (check them out from subversion etc.) Toad Data Modeler allows you to open them from the Application View.

To open an existing file

Right-click the file name in the Application View and select Open File.

Sample User Defined Structure of Custom Project with Version Control System

Legend

Direct Comparison

To compare any two revisions of the same model:

  1. In Application View, locate your Model tracked by SVN and open History Browser either from toolbar, or context menu (Subversion | History).

  2. In History Browser, select two of the available revisions and click either on Compare Revisions or Generate Change Script button on the toolbar.

  3. In the opened dialog, you can see the differences between the models.

  4.  You can now choose an action depending on the button you have clicked on before:
    • Compare Revisions - a comparison report can be generated by clicking the Report button.
    • Generate Change Script - finish the comparison to generate a change script.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating