Chat now with support
Chat with Support

Toad Data Modeler 7.0 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 MySQL 8.0 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Specifics - Oracle 12c Release 2 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 SQLite 3.7 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
Copyright Legal Notices

Git Version Control

To configure git

Configure Toad Data Modeler to work with Git in Options | Application | Version Control System. The values set here will be your default values for setting up new repositories in Toad Data Modeler

  1. Select Git in Type
  2. Set paths to your Git client and working directory for your repository
  3. Click Apply and Initialize Local Repository. The folder will be created (if it does not exist) and initialized
  4. Enter a path to the remote repository, user name, and password
  5. Click Apply and Clone Repository

Git application view

  • The following Git commands are displayed in Application View toolbar when you work with a model that is tracked:

Application View Button Description
Version Control System Settings Opens Options page where you can set the Version Control System preferences
Refresh Refreshes file status in Toad Data Modeler
Add to Index Adds the file to the list of tracked files
Remove from Index Removes the file from the list of tracked files
Commit Commits changes
Push Pushes the committed changes into the remote repository
Pull Pulls the current state from the remote repository
Fetch Fetches information about the current state of the remote repository
Information Displays information about the commit and its author
History Browser Allows you to browse different versions of the file, merge and compare them and create change script

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

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

  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!
Related Documents