|
|
SwisSQL DBChangeManager is a Web-based, simple and easy to use tool that enables you to compare and synchronize schema objects of two Microsoft SQL Server databases. DBChangeManager will compare and synchronize all database objects including, but not limited to, Tables, Stored Procedures, Views, User-Defined Functions, XML Schema Collections, and CLR Assemblies.
It is a very common every day need of a DBA/Developer to have two databases synchronized for any changes done to the schema object structure. Need for synchronization could be between two development databases or between a development and test/staging/production databases or any such combinations. DBChangeManager can effectively compare and synchronize any two SQL Server databases without any corruption or loss of Schema objects and data, saving huge amount of manual work.
Salient Features of DBChangeManager:
SwisSQL DBChangeManager is built on a client-server model with Web-based user interface accessible from anywhere through your Web Browser. With Web-based access to enterprise applications becoming the de-facto industry standard, DBChangeManager architecture enables DBA's/Developers to manage their critical database change management tasks also through a familiar Web based front-end. This architecture also enables DBChangeManager to easily support multi-user access and collaboration through defined user logins.
SwisSQL DBChangeManager contains the following components:
Advantages of DBChangeManager Architecture:
Although DBChangeManager architecture is conducive for multi-user access, it is perfectly suitable for a single user mode, enabling access of database change management functionality from anywhere through a familiar Web based interface.
SQL Server database schema change management using DBChangeManager is primarily a four-step process:
Schema comparision is the first and the core functionality of DBChangeManager. You can compare any two SQL Server databases and identify the structural differences in the schema objects that exist between them.
DBChangeManager supports 2 types of comparison resources as discussed under Resources for Schema Comparison which includes Live Databases and SQL Script files. You can provide any of these resources for doing the comparison. Two valid SQL Server Database resources are required for doing a schema comparison.
On providing the necessary SQL Server database resources for comparison, DBChangeManager performs the comparison and provides the results in a easy to understand format. Users could go through the differences between the two SQL Server databases in a very granular way and choose the schema objects to be synchronized.
You could also export the results into an HTML format and use it for offline review or printing.
Once you review the changes and choose the schema objects to be synchronized, you choose the database that is to be synchronzed (direction of synchronization) and also provide the necessary synchronization settings. DBChangeManager will synchronize the databases based on the settings provided. If DBChangeManager encounters any errors during synchronization, it will automatically rollback all the changes done till then and bring the database to its previous state as it was before synchronization.
DBChangeManager also spots potential problems for synchronization and provides necessary warnings even before you start doing the synchronization.
As comparisons and synchronizations keep happening in the databases, you can review the history of the database changes being done using DBChangeManager at any point in time. DBChangeManager provides synchronization audit feature, which helps you to review all the synchronizations that has been done so far by a user on any database. This enables auditing of database changes any time on need.
DBChangeManager is useful to DBAs and Developers who work with multiple SQL Server databases.
DBChangeManager can also be used by xSP (Hosted Service Providers) or ISP (Internet Service Providers) who provide hosted SQL Server databases to their clients. Service Providers could integrate DBChangeManager as part of their hosted service offering and enable their end-users to handle SQL Server change management tasks easily through DBChangeManager, accessing it remotely from anywhere through a Web Browser.
|
|