SQL Server uses the term “databases,” instead of “users.” In contrast to Oracle, users and databases are independent and are mapped and linked using security settings.
The following features are not supported by SQL Server industry models:
- Jobs
- Oracle data import into enterprise industry models using attribute mapping
- Profiles
- Oracle Schema Converter
- Security Administrator
- SQL Sheet
- 3D-enabled functionality
- The ability to work offline by moving data into a SQLite-based file
The main steps for setting up a new enterprise industry model are as follows. Each step is documented in detail in the linked topics.
Steps in this workflow: