Since about 75% of all software developers write applications that make use of databases, managing schema changes in their development, testing, staging and production environments can be overwhelming and very difficult to accomplish. Up until now the database professional has been left out the development life cycle. This brand new tool will allow the people who develop the application databases to become a full fledge member of the software development team, yeah! With this tool we advocate that there should be one version of the truth for the data and one version of the truth for the schema. Team System Edition for Database Professionals manages the one version of the truth for your database schema objects in a disconnected off-line environment, storing them in source control allowing the schema to be versioned and shared with the rest of the team.
Team Edition for Database Professionals Overview
- Keeping code changes and database changes in sync
- Visual Studio Database Projects
- Isolating development work on database objects
- Testing procedure and schema changes by generating test data
- Production Like Data Generation
- Promoting database changes
- Build and Deployment
- Rename/Refactoring Schema Objects
- Schema compare and synchronization
- Data compare and synchronization