How to map columns

Studio for SQL Server allows you to map columns with non-equal names. You may map columns with different types, however this may result in data truncation, rounding, and errors during synchronization for certain types. If such a situation is possible, a warning icon Caution appears in Target Column of the Select columns for comparison grid. If the columns are not compatible and cannot be compared, the Error icon appears near this column. For more information about types compatibility and mapping warnings, see the Mapping Warnings and Types Compatibility topics.

For customizing column mapping the Column Mapping dialog box is used. To open it, click the Ellipsis button in the Columns in Comparison column on the Mapping page of the Data Comparison wizard.

Mapping columns

Notes

  1. Actual document look may slightly vary from the above image depending on the product you use.
  2. If you want to remap already mapped columns, you should unmap them first.

How to unmap columns

Click the corresponding cell in the Target Column column and choose None.

How to map columns

Click the corresponding cell in the Target Column column and choose the column you need.

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?
Download a free 30-day trial