Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What rules does TOYS use to auto-map schemas?

April 26, 2017Auto map rules schemas TOYS

0

10 Posted

What rules does TOYS use to auto-map schemas?

1 Answer

0

Posted

Whenever you compare databases, TOYS needs to know which schemas in the reference database are to be matched against the schemas in the working database. In the simple case of one schema in each, the answer is easy. What happens when both databases contain many schemas and the names are different? TOYS provides you with a mapping dialog to allow you to match up the schemas in the working database with those in the reference database. This dialog presents the schemas and roles present in the working and reference database snapshots in two lists side by side. The list on the left (right) has schemas and roles from the working (reference) database. Using this dialog you have to match up each of the schemas /roles on the left to those on the right. To get you started TOYS applies a few simple rules to auto-map as many entries as possible. Here are the rules used.