MigrateTool

MigrateTool

Advanced Database Object and Data Copy

MigrateTool is included in the following product


AtanaSuite's MigrateTool allows you to easily establish a connection with any of your Teradata databases and simply drag-n-drop objects from one to another. MigrateTool 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!

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

MigrateTool 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 MigrateTool 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 MigrateTool 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!

MigrateTool Screenshots

Click on an image below to expand.

MigrateTool

Databases

MigrateTool

Objects

MigrateTool

Progress

MigrateTool Features

Some of the key features within AtanaSuite MigrateTool

Feature
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!
Feature
Column Mapping
Change column mappings as part of the migration for finer control over data movement.
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
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
Cross Server Support
Migrate 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
Data Sampling
Multiple data sampling options also available.
Feature
Multiple Statistics Options
Several options provided for handling statistics copy and recollection.
Feature
Multiple If Object Exists Options
Overwrite, prompt, skip or copy data only options if target object already exists.
Feature
Combined Progress Log
Window displays realtime operation progress and detailed operation results log.
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
Multiple Data Options
Copy objects and data, copy data only or exclude data.
Feature
Object Editor
Edit object DDL before migrating! Change column data types, table settings and other DDL type attributes to make changes on the fly.
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
View Data Copy
Copy data using views.
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.