Cloning a Teradata Database or User - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
poj1484765174891.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
Product Category
Teradata Tools and Utilities
Cloning a database or user creates a new database or user that starts with the same properties as the original database. You can change any of those properties before you create the new database or user.
  1. In the Navigator, right-click Databases and click Show Databases. A list of the databases and users in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. Right-click the database or user you want to clone, and click Open Database/User.
  3. Enter a unique name for the new database or user, and modify any properties you want to change by entering new information into the property fields.
  4. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to modify the database or user.
  5. Click Commit. The new database or user is created in the connected database.
  6. Click OK. The clone property form is replaced by a property form for the new database or user.