Comparison and synchronization of database schemas

Marcin Budny, Katarzyna Harężlak

Abstract


This paper covers a problem of comparison of two relational database schemas, which may appear during work on a daily basis of both application developers and database administrators. In order to solve this problem, a set of mechanisms for application automating this task was suggested. Among those mechanisms there are transformation of database schemas to object model, data type mapping and differential DDL script generation.

Keywords


database schema comparison; object data model; DDL scripts

Full Text:

PDF

References


Automated Office Systems. DBCompare. http://www.automatedofficesystems.com/products-/dbcompare/, 2007.

Boodhoo J.P.: Design Patterns: Model View Presenter. http://msdn.microsoft.com/en-us/magazine/ccl88690.apsx, 2008.

Budny M., Harężlak K.: Usage of the universal object model in database schemas comparison and integration, International Conference On Man-Machine Interactions, http://icmmi.polsl.pl, 2009.

Comparison of different SQL implementations. http://troels.arvin.dk/db/rdbms/, 2007

Fowler, Martin. UML Distilled: A Brief Guide to the Standard Object Modeling Language. Addison-Wesley, 2003.

Microsoft. SQL Server Books Online. http://msdn.microsoft.com/en-us/library/ms130214.aspx, 2008.

Oracle. Oracle Database Online Documentation 10g Release 2. http://www.oracle.com/pls-/dbl02/homepage, 2008.

Randell, Brian A. Introducing Visual Studio 2005 Team Edition for Database Professionals. http://msdn.microsoft.com/en-us/magazine/ccl63472.aspx, 2007.

Red Gate. SQL Compare. http://www.red-gate.corn/products/SQL_Compare/index.htm, 2007.

SQL 2003 Standard. http://www.wiscorp.com/sql_2003_standard.zip, 2007.




DOI: http://dx.doi.org/10.21936/si2010_v31.n2A.381