Competition: What’s your favorite Redgate tool? Enter now.

FieldMapping not valid for MatchingMappings

mtranmtran Posts: 34
I have been receiving this error numerous times when using SQL Data Compare.

It successfully registers the databases but I get a Mapping error and can not move forward.

I don't have any special options set. It seems this error is occurring when I use one of the saved projects. When I go in and setup a new project with the exact same databases and servers, it works fine.

I have also used previous versions to compare the databases. I have only seen this error when I started using versin 8.

Also, how would i delete saved projects? because of this bug, I have many of the same projects.

Thanks

Comments

  • You can delete projects by right clicking on the project, locating it in the file system, then deleting the file.

    I think there have been some bug fixes in the area, so if you find that your project file get corrupted after you've recreated them in v8, please let us know and we'll do our best to troubleshoot it.

    Kind regards,

    David Atkinson
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
  • I continue to receive this error for saved projects.

    Maybe some useful information for debugging:
    The databases are on SQL Server 2008.
    I am running Windows 7.
    I have gotten all updates, currently running version 8.1.0.4.

    If I change the database for comparison, I get the error.
  • I have also been getting the error. As a test I did the following:

    Compare Database1 to Database3 - success
    Compare Database2 to Database3 - success
    Compare Database1 to Database2 - failure

    Starting a project from scratch allowed me to compare Database1 to Database2
Sign In or Register to comment.