Team development with Enterprise Edition
Database Workbench Enterprise Edition is aimed at development teams and offers additional features useful for multi-person development:
- Central repository of registered servers and databases
- Shared Code and SQL Catalogs
- Public folders in the Workspace Project
- Version Control System
Centralized Repository
Besides your own personal registered servers, databases, SQL and Code Catalogs, the Enterprise Edition offers an additional set of these items stored in the TeamServer. Everyone connected to the TeamServer sees these additional items in Database Workbench.
- Central repository of registered servers and databases
- Shared Code and SQL Catalogs
- Shared To-Do Lists and public Workspace folders
Your personal server and database registrations and catalogs are stored on your local machine, the Team tab holds the same items whereever you use Database Workbench Enterprise.
Detailed TeamServer Privileges
The TeamServer Console allows you to modify privileges for TeamServer users. These privileges are Database Workbench specific and, for example, disallow certain users to drop a database or modify a server registration. You can also assign users to groups with specified privileges.
The Version Control System privileges are managed in here too.
Version Control System
Once a database is added to the TeamServer VCS, you can add database items to the repository. Whenever you want to modify an object, lock it by using "Check Out", modify it and save it to the database, while the script gets recorded to the VCS. When you're done, use "Check In" to mark your modifications as finished too.
As each revision has the DDL stored, you can check for changes and see how the object has changed, or use the VCS Browser to get the meta data change script for each revision.
