Datometry qShift

Accelerate Data Migration, Start the Replatforming Journey

Datometry qShift Overview

Datometry qShift automatically converts the legacy or source data warehouse schema into the cloud or modern data warehouse of choice.

qShift takes into account all of the existing objects in the source data warehouse schema and generates the appropriate DDL queries for the destination data warehouse.

qShift is powered by the Datometry Adaptive Data Virtualization technology.

Shifting Schema to Cloud

Why Datometry qShift

Fast icon

Faster Data Migration

qShift saves months of specialized manual effort required to convert the schema from the existing data warehouse.

Reduced Cost icon

Reduced Cost

qShift is an order of magnitude lower in cost when compared to manual schema migration effort.

De-risk icon

De-risk Data Migration

qShift can significantly reduce the risk of a data migration effort by eliminating the error prone manual schema conversion process.

Automated icon

100% Automated

Unlike other tools in the market, qShift is a full-featured product that converts 100% of the legacy data warehouse schema.

Fortune 500 Retailer


With qShift, our enterprise completed a 100TB data migration within days, saved hundreds of thousands of dollars and significantly reduced the risk of replatforming.

While the cost and time savings of qShift was a no-brainer, it was the reduced risk of automated schema mapping that was the deciding factor for our enterprise to replatform with the Datometry Solution.

Datometry qShift Features

Datometry qShift automatically and instantly generates the schema for the destination data warehouse taking into account existing tables and objects in the source data warehouse schema. qShift generates the appropriate DDL queries for the destination data warehouse and creates the empty tables and views.

Updatable Views

Updatable views transferred by qShift are handled dynamically through Hyper-Q in real-time when the application invokes those views.

Datatype Matching

qShift will keep track of the datatype mismatches for Hyper-Q to use during query translation and query transformation.

Stored Procedures and Macros

qShift preserves the original Stored Procedures and Macros for use by Hyper-Q emulation.

Supported Systems: qShift can take schema from Teradata 13 or higher versions and synthesize schema for Azure SQL DW, AWS Redshift or Pivotal Greenplum.


Datometry qShift is a SaaS offering that automates the generation of schema for the destination cloud data warehouse instantly and with full accuracy.

qShift supports AWS Redshift, Azure SQL Data Warehouse and Greenplum databases. It also supports Azure SQL DB, AWS Aurora Postgres and AWS Spectrum. Please reach out to contact@datometry.com for questions regarding other target data warehouses.

Datometry qShift accelerates data migration and speeds up replatforming to the cloud.