|
|
|
|
|
Schema Manager 1.0 1 2 3 4 5 6 7 Schema Manager is a relatively new product from Embarcadero Technologies. It represents a new path that Embarcadero is going down for products. They have 3 core products: DBArtisan, RapidSQL, and ER/Studio. Schema Manager is the first utility type of tool that is designed to accomplish a very focused piece of functionality. The roots of all of the functionality in Schema Manager can be found at various points within DBArtisan. This functionality has been packaged into a new product and extended.Note: Schema Manager has been renamed to DBArtisan Change Manager. I will use Schema Manager in this review to avoid confusion with the title bars in the screen shots. The sole purpose in life for Schema Manager is to help you get a handle on changes within your production and development environments. How many times have you asked the question: What are the differences between my development and production databases or what are the differences between Server A and Server B? How many times have your developers made mass changes to a development environment and then told you to implement them in production? While you can accomplish this using existing tools, it is a very tedious, manual process that will consume a significant amount of time. Schema Manager streamlines this process by allowing you to quickly compare databases and generate scripts to apply changes. It can also keep track of versions and allow you to roll back a schema to a previous version. The figure below shows the main workspace. There are three main functions you can accomplish from here: capture, compare, and migrate.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
