White Papers

Database Deployment: Synchronizing Database Structures

Overview Developing and deploying a new database is never easy. Manually synchronizing new revisions of database structures with an already running system can become a nightmare. If one's assignment includes modifications to the structure of an existing database, one's options of performing the task without disrupting the workflow are limited. The simplest and most obvious way of synchronizing two databases would be by deleting the old database and creating new structures on top of it. If one backs up the data before deleting the old database, and restore it from the backup after one has finished updating the structures, one might just get away with it. However, this approach is unacceptable in many environments as it disrupts the workflow and does not provide reasonable security.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: Perpetuum Software
File Format: HTML
Date Published: Mar 14, 2009
Format: White Papers
Topics: Back-up, Database Management

Similiar White Papers

Oracle Recovery Manager 10g: Exploring RMAN's Unique Data Recovery Capabilities

Recovery Manager, Oracle's backup and recovery utility, was first released with Oracle 8.0 providing DBAs an integrated

Publisher: Oracle

SQL Server: A practical guide to Backup, Recovery and Troubleshooting

This e-book provides working scenarios, policy/procedure and best practice for database backup and recovery. It is for

Publisher: Imceda | Tags: database, disaster recovery, management, service management

Veritas Netbackup 6.0 Technical Overview

VERITAS NetBackup software brings the same level of storage management support to the world of open systems found in tra

Publisher: VERITAS Software | Tags: data, management, software, storage management, veritas

The Shortcut Guide to Managing Disk Fragmentation

Fragmentation results in significant money and time drain on IT resources. The Shortcut Guide to Managing Disk Fragmenta

Publisher: Diskeeper

Backup and Recovery Best Practices for SQL Server 2005, Including HP Data Protector

With databases regarded as mission critical in most companies, the ability to back up Microsoft SQL Server 2005 data whe

Publisher: Hewlett-Packard (HP) | Tags: data, database, intel

Perpetuum Software White Papers

Report Sharp-Shooter Is One of the Main Tools in AppsPlus Arsenal

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »