Choosing Single-schema or One-schema Multi-schema

You should consider the flexibility that a one-schema multi-schema project offers you before choosing a single-schema project. 

• Only a single-schema project allows you to vary the schema name across steps in the release pipeline. 
• Only a one-schema multi-schema project allows you to do the following:
  • Put the tracking tables in a different schema
  • Add schemas later

Creating a Single-schema Project

1. Right-click on the left pane and select New > Deployment Plan.
   
   
   
   
2. Enter the Project name, then click Next. You accept the following default values:
   • Single Schema - This project will manage 1 schema per Deployment Step
   • Deployment Step - Select this when schema names differ across Deployment Steps
     
     
3. Enter the Name for the step, select the Database Platform, then click Next
   
   
   
   
4. Enter the database connection information, then click Test Connection. 
   
   
   
   
5. Click Finish. 

Note that you need to add steps to the project to complete it.