Table mappings

tom.faulkner

I'm trialling v11 before updating from 9 and one key feature I require is the comparison of tables and columns that have changed name.

Upon a test, I'm getting odd behaviour.

I've set the table mappings so the renamed tables and columns are known about, some of these are still marked as partial because the renamed table also has a new field that isn't in the source - I don't expect this to cause any problems.

When I then go through to run the sync, I get warnings:

Severity: High
Object: t_TableB
Title: Column [TableAID] on table [dbo].[t_TableB] could not be matched to a column in the source table. The data in this column will be lost.

Double checking the mappings, and there certainly are mappings for the fields listed in the warning.

Any Clues ?

Thanks

Mike U

Are you using a saved project file? There have been instances where the mappings section of the saved project file gets corrupted, so if you are it would be worth trying with a completely new project.

tom.faulkner

Hi,

No, I'm creating the project from scratch each time.

Just tried again and same problem occurs. In the deployment warning it says there's no mapping available, but back in the edit project > table mappings, it says mapped ! ?

Mike U

Could you post the SQL CREATE definitions of the tables on either side of the comparison and we'll see if we can recreate the problem? If you're not happy posting them publicly, you could e-mail support@red-gate.com with the details.

tom.faulkner

Hi,

Thanks, ive sent the scripts.