Options

Is there an "Ignore Schema" option?

DavePooleDavePoole Posts: 2
edited March 17, 2011 3:12PM in SQL Compare Previous Versions
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.

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    Thanks for your post.

    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.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.