Advanced Database Object and Data Copy

CopyTool is included in the following subscription products

AtanaSuite's CopyTool allows you to easily establish a connection with any of your Teradata databases and simply drag-n-drop objects from one to another. CopyTool automatically generates the object definition and corresponding color-coded DDL. Editor provides mechanism for altering the DDL before the copy is complete. A simple click of a button executes the DDL to create the object and even copy the data!

CopyTool offers convenient tool-to-tool integration. Overwrite protection prevents accidental object replacement.

CopyTool lets you spend time getting the work done instead of figuring out how to do the work!

No more looking up object definitions, no more writing "Create" scripts - simply drag-n-drop the objects you want to copy to the target server! Quickly set up test instances: duplicate or alter objects. Even copy data filtered by a "WHERE" or sample clause!

Using AtanaSuite CopyTool is as easy as drag-n-drop - select the databases and objects to go after, edit the DDL, specify the data options, click execute and AtanaSuite CopyTool does the rest. It can migrate objects, tables and data, and even views and data!

Save your selections as an AtanaSuite Active Script job for re-use later!

CopyTool Screenshots

Click on an image below to expand.







CopyTool Features

Some of the key features within AtanaSuite CopyTool

Drag-n-Drop Object and Data Migration
Drag-n-drop Teradata database objects from one database control to another. Change DDL and save without modifying originating source objects in the process. Edit columns and data by using sample and where clause filters and easily include statistics definitions and data as part of stats related object migrations. Integrated progress bar and detailed log provided for monitoring and review. Even copies across servers and supports copying data using views. AtanaSuite Active Script and Active Server enabled as well!
Column Mapping
Change column mappings as part of the migration for finer control over data movement.
Data Copy Filter
Restrict the amount of data copied by using the data copy filter.
Multiple Results Display Options
Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the operation results display.
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Cross Server Support
Migrate objects and data from production server to a test or QA server.
Drag-n-Drop Object Selection
Simply select an object or objects and drag-n-drop them into the selected area.
Data Sampling
Multiple data sampling options also available.
Multiple Statistics Options
Several options provided for handling statistics copy and recollection.
Multiple If Object Exists Options
Overwrite, prompt, skip or copy data only options if target object already exists.
Combined Progress Log
Window displays realtime operation progress and detailed operation results log.
Tool-to-Tool Integration
The AtanaSuite environment is designed to help get you to the right tool for the job by providing toolbar buttons that enable context aware loading of information from one tool to another.
Preview DDL
Preview the operation DDL before you do it - just for additional safety.
Multiple Data Options
Copy objects and data, copy data only or exclude data.
Object Editor
Edit object DDL before migrating! Change column data types, table settings and other DDL type attributes to make changes on the fly.
Object Type Option Specification
Select an object type, like tables, and apply the selected options for all tables. Select an individual object to override the object type option setting for the selected object.
View Data Copy
Copy data using views.
Fast Data Transfer
Utilizes fastest protocols available for data copy operations including TPT, FastExport and FastLoad.
Active Script Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution, modification and scheduling.