Ignoring an entire Schema

gokhanpolat · March 21, 2024 8:19AM

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 ?

David Atkinson · March 21, 2024 10:17AM

Yes, this is possible. In the Edit Project dialog there is an Owner Mapping page which allows differently named schemas to be mapped.

gokhanpolat · March 21, 2024 10:35AM

David Atkinson said:

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

David Atkinson · March 21, 2024 10:56AM

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

Ignoring an entire Schema

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk