Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > White Paper-Technical > Sybase IQ 15.0 - Database Migration

Sybase IQ 15.0 - Database Migration

This document provides a brief introduction to the IQ database migration tool, process involved and a migration example.
 
RSS Feed
 
 
 

Introduction

Sybase IQ 15.0 includes many new features: enhanced multiplex capabilities, table spaces and data partitioning that support Information Lifecycle Management (ILM) capabilities and extensive query parallelism. Additionally, its class-leading performance has also been significantly strengthened. To achieve this, parts of the server have undergone substantial changes; in the case of the catalog store; a new storage format has been adopted.

The catalog store in Sybase IQ 12.7 worked with all earlier versions of the product; the server included logic that supported all functionality in each earlier version. Database migration was straightforward - users simply performed an "alter database upgrade" when upgrading to the next version of Sybase IQ. This simple process was called upgrading the database. From an engineering perspective, however, the support for legacy versions imposed severe limitations, making it cumbersome to deliver new and innovative features. Additionally, legacy code also restricted the type of optimizations that could be performed.

As part of the upgrade to Sybase IQ 15.0, a database file migration is now required, rather than a simple database upgrade. A new fully automated migration tool - iqunload - included with Sybase IQ 15.0, re-creates the catalog store and reloads it with existing database schema metadata. Only the catalog is re-created; the IQ data and temp dbspaces are not changed.

The migration process is completely automated, self-contained, and does not require your existing Sybase IQ 12.7 software. There are a few premigration steps you need to follow to ensure a smooth and error-free migration.

This document provides a brief introduction of the migration tool and process that should be followed to do the migration.

Click here to view the complete document (PDF)


 

DOCUMENT ATTRIBUTES
Last Revised: Jul 21, 2009
Product: Sybase IQ
Technical Topics: Migration
  
Business or Technical: Technical
Content Id: 1064952
Infotype: White Paper-Technical
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics