How can we help you today? How can we help you today?

Ignoring an entire Schema

I will compare database for MSSQL but I want to ignore schema differences. As an example I will compare two databases

1.Database Name : A
2.Database Name : B

Schema of database A A1
schema of database B B1

gives me the following output as an example. 

A1.ExampleTable in database A does not exist in database B. But I have the same table named B1.ExampleTable. So can I make a comparison by ignoring the schema ?

gokhanpolat
0

Comments

3 comments

Sort by
  • David Atkinson
    Yes, this is possible. In the Edit Project dialog there is an Owner Mapping page which allows differently named schemas to be mapped.
    David Atkinson
    0
  • gokhanpolat
    Yes, this is possible. In the Edit Project dialog there is an Owner Mapping page which allows differently named schemas to be mapped.
    As you can see in the picture, I couldn't find a setting for pairing. Is there a tutorial on this?

    https://ibb.co/R388x7L




    gokhanpolat
    0
  • David Atkinson
    You have to unmap the schemas and remap them as per your needs.
    This is described in our product documentation.
    David Atkinson
    0

Add comment

Please sign in to leave a comment.