Exercise: Create Schema and assign Behavior

  1. In the MDW right click Database Schemas node and choose Add Database Schema
  2. Type dbo in the Name box and click OK
  3. Create schema ETL the same way
  4. Expand the Database Schemas node, right click ETL schema and choose Schema Behavior -> Main default schema
  5. Right click dbo schema and choose Schema Behavior -> Main Valid default schema
  6. Right click MDW node, choose Deploy and Execute and remove the tick at Enable differential deployment (To make sure all objects in MDW are included)
  7. click Start and Save