Image

CopyTool

Advanced Teradata Database Object and Data Copy

Available in

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!

Tool Screenshots

Screenshots of CopyTool in action.

Key Features

Some of the key features found in CopyTool.

CopyTool Screenshots

Click on an image below to expand.

Image

Databases

Image

Objects

Image

Progress

CopyTool Features

Some of the key features within CopyTool

Badge ImageDrag-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!
Badge ImageHeader
Change column mappings as part of the migration for finer control over data movement.
Badge ImageHeader
Restrict the amount of data copied by using the data copy filter.
Badge ImageMultiple Results Display Options
Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the operation results display.
Badge ImageHeader
Available throughout the product that provides exporting results to the most popular formats including Excel.
Badge ImageHeader
Migrate objects and data from production server to a test or QA server.
Badge ImageHeader
Simply select an object or objects and drag-n-drop them into the selected area.
Badge ImageHeader
Multiple data sampling options also available.
Badge ImageHeader
Several options provided for handling statistics copy and recollection.
Badge ImageHeader
Overwrite, prompt, skip or copy data only options if target object already exists.
Badge ImageCombined Progress Log
Window displays realtime operation progress and detailed operation results log.
Badge ImageTool-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.
Badge ImageHeader
Preview the operation DDL before you do it - just for additional safety.
Badge ImageHeader
Copy objects and data, copy data only or exclude data.
Badge ImageHeader
Edit object DDL before migrating! Change column data types, table settings and other DDL type attributes to make changes on the fly.
Badge ImageObject 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.
Badge ImageHeader
Copy data using views.
Badge ImageFast Data Transfer
Utilizes fastest protocols available for data copy operations including TPT, FastExport and FastLoad.
Badge ImageActive Script Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution, modification and scheduling.

AtanaSuite

AtanaSuite is a proven leader in development, management, query, visualization, compression and synchronization productivity products for popular databases including Teradata and Vantage!