• User Guide
  • Introduction
    • Introducing Actian Director
    • Installation
    • Intended Audience
    • Internet Connectivity
    • Documentation
      • Access Local Help
    • Path Notation in This Guide
    • Your Support Options
  • Getting Started with Director
    • Interface Design
      • Instance Explorer
        • Hide or Show the Instance Explorer
      • Multiple Document Interface
        • Document Types
        • Select a Document
        • Close a Document
        • Save an Unsaved Document
      • Main Menu Ribbon Tabs
        • Home Tab
        • Connection Tab
        • Database Tab
        • Query Tab
        • Help Tab
      • Toolbars
        • Instance Explorer Toolbar
        • Dialog Toolbar
        • Query Document Toolbar
    • Setting Options for Director
      • Options Dialog
        • Environment Options (Options Dialog)
        • Query Execution Options (Options Dialog)
        • Query Results Options (Options Dialog)
      • Set Whether to Prompt Before Disconnecting the Instance Explorer
      • Set Whether to Show Advanced Connect Options
      • Set the First <n> Rows to Select in the Instance Explorer
      • Set the Size of Support Log Files
      • Specify Fonts Used in Queries and Results
      • Syntax Coloring
      • Set the User Interface Language
      • Set Connection and Startup Options
      • Set the Maximum Number of Rows to Return When Executing a Query
      • Specify Runtime SET Options
      • Specify Default Output Format and Location for Query Results
    • Access Local Help
  • Connecting to and Disconnecting from Actian Database Installations
    • About Connection
    • Instance Code
    • Format of Installation Names
    • Connecting to an Ingres or Actian Vector Installation
      • Connecting to an Already-Connected Installation
      • Default Connection
      • Connection at Startup
      • Automatic Connection
        • Configure for Automatic Reconnection at Startup
      • Connect to Instance Dialog
        • Connection Errors
      • Start a Local Management Server (Windows Only)
      • Connect to an Actian Database Instance
    • Connecting to a Database Using a Server Connection Definition
    • Disconnecting from an Actian Database Installation
      • Disconnect from an Actian Database Installation
    • Removing an Actian Database Installation
      • Remove an Actian Database Installation
    • Move an Instance Up or Down in the Instance Explorer
    • Set an Installation Password
    • Viewing Instance Properties
      • Instance Properties Dialog
        • General Page Options
        • Environment Page Options
      • View Installation Properties
    • Setting DBMS Trace Options for an Installation
      • DBMS Trace Options Dialog
        • General Page Options
        • Output Log Page Options
      • Set DBMS Trace Options
    • Translating Between Instance IDs and Port Values
    • Display and Search Log Files
  • Starting and Stopping Actian Database Instances and Components
    • About Starting and Stopping Components
    • Start Operations
      • State Indicators
      • Startup Errors
      • Start Confirmation and Progress Dialog
      • Start an Instance
      • Start a Stopped Server
    • Stop Operations
      • Stopping Errors
      • Stop Confirmation and Progress Dialog
      • Stop an Instance
      • Stop a Running Server
  • Browsing Databases and Objects
    • About Browsing
    • Instance Explorer Structure
    • Browse Object Properties
      • Non-browsable Objects
    • Installation Node
      • Databases Folder, Database Node
        • Tables Folder, Table Node
        • Views Folder, View Node
        • Procedures Folder, Procedure Node
        • Sequences Folder, Sequence Node
        • Events Folder, Database Event Node
        • Synonyms Folder, Synonym Node
        • Security Folder at Database Level
      • Security Folder at Installation Level
        • User Node at Installation Level
        • Group Node
        • Role Node
        • Profile Node
      • Server Connection Definitions Folder
        • Server Connection Definition (vnode)
      • Locations Folder, Location Node
      • Management Folder
  • Working with Databases
    • Database Operations
    • Object Naming Rules
    • Creating and Deleting Databases
      • Creating a Database
        • New Database Dialog
        • Create a Database
      • Deleting a Database
        • Delete Database Dialog
        • Delete a Database
    • Backing Up and Restoring Databases
      • Backup Database Dialog
      • Back Up a Database
      • Restore Database Dialog
      • Restore a Database
    • Creating and Modifying Database Locations
      • Location Dialog
      • Create a Location
      • Modify a Location
      • Delete a Location
    • Working with Views
      • New View Dialog
      • Create a View
      • Delete a View
      • Display View Properties
    • Working with Procedures, Sequences, Events, and Synonyms
      • Procedures
        • Procedure Dialog
        • Create a Procedure
        • Modify a Procedure
        • Delete a Procedure
        • View Procedure Properties
      • Sequences
        • Sequence Dialog
        • Create a Sequence
        • Modify a Sequence
        • Delete a Sequence
        • View Sequence Properties
      • Events
        • Database Event Dialog
        • Create an Event
        • Delete an Event
        • View Event Properties
      • Synonyms
        • Synonym Dialog
        • Create a Synonym
        • Delete a Synonym
        • View Synonym Properties
    • Using Rules
      • New Rule Dialog
      • Create a Rule
      • Delete a Rule
      • View Rule Properties
    • Generating Statistics
      • Generate Statistics Dialog
        • General Page (Generate Statistics Dialog)
        • Options Page (Generate Statistics Dialog)
        • Display Formatting Page (Generate Statistics Dialog)
        • Input/Output Files (Generate Statistics Dialog)
        • Output Log (Generate Statistics Dialog)
      • Generate Statistics
    • Displaying Statistics and Information
      • Display Statistics Dialog
        • General Page (Display Statistics Dialog)
        • Options Page (Display Statistics Dialog)
        • Display Formatting Page (Display Statistics Dialog)
        • Output File Page (Display Statistics Dialog)
        • Output Log Page (Display Statistics Dialog)
      • Display Statistics
      • Display Database Information Dialog
      • Display Database Information
    • Modifying System Tables and User Tables
      • Modifying System Tables (Catalogs)
        • Modify System Tables Dialog
        • Modify System Tables
      • Modifying User Tables (Catalogs and Secondary Indexes)
        • Modify User Tables Dialog
        • Modify User Tables
    • Verifying Databases
      • Verify Database Dialog
      • Verify a Database
    • Altering Databases
      • Alter Database Dialog
      • Alter a Database
    • Extending Databases
      • Extend Database Dialog
      • Extend a Database
    • Viewing Database Properties
      • Database Properties Dialog
      • View Database Properties
    • Setting DBMS Trace Options for Databases
      • DBMS Trace Options Dialog
      • Set DBMS Trace Options
    • Display Log Files
  • Working with Tables
    • About Working with Tables
    • Creating Tables
      • New Table Interface
        • Table Properties
        • Select Locations Dialog
        • Partition Specification Dialog
        • Column Operations
      • Create a Table
        • Specify Locations
        • Partition the Table
      • Save a Table
      • Create a Table Using a Select Statement
        • New Table from Select Dialog
    • Deleting Tables
      • Delete a Table
    • Foreign Keys, Indexes, and Constraints
      • Creating Primary Keys, Foreign Key Constraints, and Indexes for Actian Vector Tables
      • Assign Primary Keys
      • Foreign Key Relationships
        • New Foreign Key Dialog
        • Create a Foreign Key Relationship
        • Delete a Foreign Key Relationship
      • Constraints
        • New Constraint Dialog
        • Create a Constraint
        • Delete a Constraint
      • Indexes
        • Index Dialog
        • Create an Index
        • Delete an Index
    • Viewing Table Properties
      • Table Properties Dialog
      • View Table Properties
    • Loading Data into Actian Vector
      • Import Data into an Actian Vector Table with the Import Wizard
        • Start the Import Wizard
        • Choose a Data Source
        • Configure Columns
        • Specify the Data Destination
        • Configure the Data Mappings
        • Complete the Wizard
        • Monitor Import Execution
        • How the Import Wizard Handles Newly Created Tables
        • Failed Import Records
        • vwload Escape Sequences
      • Load Data into an Actian Vector Table Dialog
      • Load Data into an Actian Vector Table
  • Using Queries
    • About Using Queries
    • Object Naming Rules
    • Create a New Query
    • Query Options Dialog
    • Query Status Bar Fields
    • Open an Existing Query
      • File Chooser Dialog
    • Find or Replace Text in a Query
    • Save a Query
    • Close a Query
    • Specify Default Output Format and Location for Query Results
    • Specify Output Format for Query Results
    • Specify Fonts Used in Queries and Results
    • Execute a Query
    • Cancel a Running Query
    • Copy Query Results
    • Save Query Results
    • DBMS Trace Message Display
    • Recording Queries
      • Start Recording Queries Dialog
      • Start or Stop Recording Queries
  • Managing Server Connection Definitions
    • How You Can Use Server Connection Definitions
    • Creating Server Connection Definitions
      • New Server Connection Definition Dialog
      • Create a Server Connection Definition
    • Testing a Server Connection Definition
      • Test a Server Connection Definition
    • Running a Script from a Control File
      • Run a Script
    • Modifying Server Connection Definitions
      • Modify Server Connection Definition Dialog
      • Modify a Simple Server Connection Definition
    • Creating and Modifying Login Information for Server Connection Definitions
      • Login Dialog
      • Create a New Login for an Existing Server Connection Definition
      • Modify a Login for an Existing Server Connection Definition
    • Creating and Modifying Connection Data
      • Connection Dialog
      • Create a New Connection for an Existing Server Connection Definition
      • Modify a Connection for an Existing Server Connection Definition
    • Creating and Modifying Attributes for Existing Server Connection Definitions
      • Attribute Dialog
      • Create an Attribute for an Existing Server Connection Definition
      • Modify an Attribute for an Existing Server Connection Definition
    • Deleting Server Connection Definitions
      • Delete a Server Connection Definition
      • Delete a Login for an Existing Server Connection Definition
      • Delete a Connection for an Existing Server Connection Definition
      • Delete an Attribute for an Existing Server Connection Definition
    • Connecting to a Database Using a Server Connection Definition
  • Administering Users, Groups, Roles, and Profiles
    • About Administration
    • Creating Users, Groups, Roles, and Profiles
      • User Dialog
        • General Page (User)
        • Privileges Page (User)
        • Roles Page (User)
        • Access Page (User)
        • Options Page (User)
      • Create a New User
      • Group Dialog
        • General Page (Group)
        • Access Page (Group)
      • Create a New Group
      • Role Dialog
        • General Page (Role)
        • Privileges Page (Role)
        • Grantees Page (Role)
        • Access Page (Role)
        • Options Page (Role)
      • Create a Role
      • Profile Dialog
        • General Page (Profile)
        • Privileges Page (Profile)
        • Options Page (Profile)
      • Create a New Profile
    • Modifying Users, Groups, Roles, or Profiles
      • Modify a User
      • Modify a Group
      • Modify a Role
        • Grant or Revoke Roles for Multiple Users
      • Modify a Profile
    • Deleting Users, Groups, Roles, or Profiles
      • Delete a User, Group, Role, or Profile
    • Viewing Properties for Users, Groups, Roles, or Profiles
      • View Properties for Users, Profiles, Groups, or Roles
  • Managing Servers and Transaction Logs
    • About Managing Servers and Transaction Logs
    • Management Folder
    • Configuring Servers
      • Start and Stop Servers
      • Set a Server Startup Count
      • View Hadoop Instance Properties
  • Managing Permissions and Viewing Properties
    • Object Permissions
    • Object Types with Permissions
      • Object Ownership and Granting Object Permissions
    • Grantees
    • Permissions Dialog
    • Set Permissions for Objects
    • Viewing or Modifying Permissions
      • View Permissions
      • Modify Permissions
    • Viewing Properties
      • View Properties Dialog
      • Viewing Properties for Objects
      • Copy Settings from Properties Dialogs

User Guide

Copy Settings from Properties Dialogs