CopyTool

CopyTool

Simple Database Object and Data Copy

CopyTool is included in the following products


AtanaSuite's CopyTool makes object and data copying a snap! Simply drag-n-drop objects from source server database to target server database. CopyTool automatically generates the object definition and corresponding color-coded DDL. 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 to prevent accidental object replacement and detailed logging.

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 tables, views, macros, procedures, triggers - Even copies data!

Using AtanaSuite CopyTool is as easy as drag-n-drop - select the databases and objects to go after, specify the data options, click execute and AtanaSuite CopyTool does the rest. It can copy 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

Databases

CopyTool

Objects

CopyTool

Progress

CopyTool Features

Some of the key features within AtanaSuite CopyTool

Feature
Simple Drag-n-Drop Object and Data Copy
Drag-n-drop Teradata database objects from one database control to another, specify data option and click execute! 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!
Feature
Multiple Data Options
Copy objects and data, copy data only or exclude data.
Feature
Data Copy Filter
Restrict the amount of data copied by using the data copy filter.
Feature
Multiple Results Display Options
Multi-column grouping, filtering, ordering and sorting provide all the necessary features for individually customizing the operation results display.
Feature
Combined Progress Log
Window displays realtime operation progress and detailed operation results log.
Feature
Cross Server Support
Copy objects and data from production server to a test or QA server.
Feature
Drag-n-Drop Object Selection
Simply select an object or objects and drag-n-drop them into the selected area.
Feature
Multiple Statistics Options
Several options provided for handling statistics copy and recollection.
Feature
View Data Copy
Copy data using views.
Feature
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
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.
Feature
Preview DDL
Preview the operation DDL before you do it - just for additional safety.
Feature
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.
Feature
Fast Data Transfer
Utilizes fastest protocols available for data copy operations including TPT, FastExport and FastLoad.
Feature
Active Script and Server Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution and modification. Purchase AtanaSuite Active Server and take advantage of its centralized job repository, scheduling, execution, monitoring and reporting features.