ER Studio 3.5 One of the biggest challenges facing database developers is creating, deploying and maintaining databases over a number of different environments. This is further complicated by the need to share data among database platforms, such as Oracle, MS SQL Server and Sybase.
Few developers have the time or inclination to learn the intricacies of so many platforms.
Enter ER Studio from Embarcadero Technologies, a tool that allows developers to design and construct a logical model of a database and apply it to different platforms, ER Studio's wizard-driven approach makes it easy to design a database with a diagram, then apply that design to a physical database. What's more, logical designs can be extracted from existing physical databases, allowing the developer to reverse engineer a database. This is useful in a number of areas, such as documenting existing databases as well as applying that design to other platforms, ensuring that designs are consistent from platform to platform. By having separate logical and physical designs for the database, an administrator can keep track of changes made by other personnel. Also, if they don't agree with the change, the logical design can be applied to the database to restore it to its original condition using the built-in merge wizard.