Table mappings
tom.faulkner
Posts: 4
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
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
Comments
Redgate Software
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 ! ?
Redgate Software
Thanks, ive sent the scripts.