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

Reply via email to