Return-Path: 
 <commits-return-32858-apmail-cassandra-commits-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-commits-archive@www.apache.org
Delivered-To: apmail-cassandra-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 9430547A5
	for <apmail-cassandra-commits-archive@www.apache.org>;
 Wed, 11 May 2011 15:36:27 +0000 (UTC)
Received: (qmail 8907 invoked by uid 500); 11 May 2011 15:36:27 -0000
Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org
Received: (qmail 8891 invoked by uid 500); 11 May 2011 15:36:27 -0000
Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:commits-help@cassandra.apache.org>
List-Unsubscribe: <mailto:commits-unsubscribe@cassandra.apache.org>
List-Post: <mailto:commits@cassandra.apache.org>
List-Id: <commits.cassandra.apache.org>
Reply-To: dev@cassandra.apache.org
Delivered-To: mailing list commits@cassandra.apache.org
Received: (qmail 8883 invoked by uid 99); 11 May 2011 15:36:27 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 May 2011 15:36:27 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED,T_RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 May 2011 15:36:26 +0000
Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116])
	by hel.zones.apache.org (Postfix) with ESMTP id A15E045561
	for <commits@cassandra.apache.org>; Wed, 11 May 2011 15:35:47 +0000 (UTC)
Date: Wed, 11 May 2011 15:35:47 +0000 (UTC)
From: "David Boxenhorn (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: 
 <908159946.3343.1305128147657.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Created] (CASSANDRA-2636) Import/Export of Schema
 Migrations
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394

Import/Export of Schema Migrations
----------------------------------

                 Key: CASSANDRA-2636
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2636
             Project: Cassandra
          Issue Type: Improvement
            Reporter: David Boxenhorn


My use case is like this: I have a development cluster, a staging cluster and a production cluster. When I finish a set of migrations on the development cluster, I want to apply them to the staging cluster, and eventually the production cluster. I don't want to do it by hand, because it's a painful and error-prone process. What I would like to do is export the last N migrations from the development cluster as a text file, with exactly the same format as the original text commands, and import them to the staging and production clusters. 

I think the best place to do this might be the CLI, since you would probably want to view your migrations before exporting them. Something like this:

show migrations N;                                   Shows the last N migrations.
export migrations N <fileName>    Exports the last N migrations to file fileName.
import migrations <fileName>                    Imports migrations from fileName.

The import process would apply the migrations one at a time giving you feedback like, "applying migration: update column family...". If a migration fails, the process should give an appropriate message and stop. 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira