Cloning a Teradata Database or User - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
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.