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 - Local Store Migration

Sybase IQ 15.0 - Local Store Migration

This document provides a brief introduction to the local store migration tool and the process you will follow to migrate your local stores to IQ 15.0
 
RSS Feed
 
 
 

INTRODUCTION

IQ 15.0 delivers enhanced multiplex (MPX) capabilities, and a new table-partitioning architecture that allows a higher degree of administration and performance capabilites. As part of these evolutionary changes, support for local stores on MPX has been removed. When you move to Sybase IQ 15.0, you must migrate local store content to a shared store withing the MPX.

Sybase IQ 15.0 includes a local store migration utility, iqlsunload. This utility allows you to unload the schema and data from an MPX local store. Once the schema and data are unloaded, DBA's can then use the generated SQL scripts to re-create the local store schema and to load the data into a shared store within the existing 12.7 MPX or the migrated 15.0 MPX.

The local store migration tool, iqlsunload utilizes many IQ features to facilitate the migration process. For example, the unloading and reloading of local store data utilizes the load and extract engine because iqlsunload generates SQL files, DBAs can edit these files, and customize the loading and reloading behaviour.

This document provides a brief introduction to the local store migration tool and the process you will follow to migrate your local stores.

 

Click here to view the complete document (PDF)

 


 

DOCUMENT ATTRIBUTES
Last Revised: Jun 04, 2009
Product: Sybase IQ
Technical Topics: Migration
  
Business or Technical: Technical
Content Id: 1063855
Infotype: White Paper-Technical
 
 
 

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