Is there an "Ignore Schema" option?
DavePoole
Posts: 2
I am attempting to reverse and forward engineer databases use Sparx Enterprise Architect and using SQLCompare 8.2.0.16
I cannot find any option to ignore the schema or owner for a table.
I have tried mapping a schema to an owner but this simply created an error telling me that dbo was unmapped.
I cannot find any option to ignore the schema or owner for a table.
I have tried mapping a schema to an owner but this simply created an error telling me that dbo was unmapped.
Comments
If you unmapped and then re-mapped your owner/schema, but left the original dbo unmapped on one side, that's the problem. It has to map to something.
The usual workaround would be to create a dummy schema in the other database that you can map the orphan one to.
Hope that makes sense - if not, we've got a support ticket open for this, so please throw a screenshot of how you've got it set up over to support@red-gate.com quoting F0045743 in the subject line.
Redgate Software