You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Kevin Burton <bu...@spinn3r.com> on 2014/07/08 17:38:52 UTC
Easy diff of schema from dev->production
Are there any easy/elegant ways to compare dev schema to production schema.
I want to find if there are any rows/columns we need to add.
I could try to format the output and just use 'diff' … but with the table
options that isn't super clean either.
--
Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
blog: http://burtonator.wordpress.com
… or check out my Google+ profile
<https://plus.google.com/102718274791889610666/posts>
<http://spinn3r.com>
Re: Easy diff of schema from dev->production
Posted by Kevin Burton <bu...@spinn3r.com>.
Ah.. I think that's what I was hoping for!
On Tue, Jul 8, 2014 at 9:05 AM, DuyHai Doan <do...@gmail.com> wrote:
> If you are using CQL3, the meta data are stored in system tables
>
>
> On Tue, Jul 8, 2014 at 5:38 PM, Kevin Burton <bu...@spinn3r.com> wrote:
>
>> Are there any easy/elegant ways to compare dev schema to production
>> schema. I want to find if there are any rows/columns we need to add.
>>
>> I could try to format the output and just use 'diff' … but with the table
>> options that isn't super clean either.
>>
>>
>>
>> --
>>
>> Founder/CEO Spinn3r.com
>> Location: *San Francisco, CA*
>> blog: http://burtonator.wordpress.com
>> … or check out my Google+ profile
>> <https://plus.google.com/102718274791889610666/posts>
>> <http://spinn3r.com>
>>
>>
>
--
Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
blog: http://burtonator.wordpress.com
… or check out my Google+ profile
<https://plus.google.com/102718274791889610666/posts>
<http://spinn3r.com>
Re: Easy diff of schema from dev->production
Posted by DuyHai Doan <do...@gmail.com>.
If you are using CQL3, the meta data are stored in system tables
On Tue, Jul 8, 2014 at 5:38 PM, Kevin Burton <bu...@spinn3r.com> wrote:
> Are there any easy/elegant ways to compare dev schema to production
> schema. I want to find if there are any rows/columns we need to add.
>
> I could try to format the output and just use 'diff' … but with the table
> options that isn't super clean either.
>
>
>
> --
>
> Founder/CEO Spinn3r.com
> Location: *San Francisco, CA*
> blog: http://burtonator.wordpress.com
> … or check out my Google+ profile
> <https://plus.google.com/102718274791889610666/posts>
> <http://spinn3r.com>
>
>
Re: Easy diff of schema from dev->production
Posted by Shane Hansen <sh...@gmail.com>.
I'd suggest looking at the system keyspace. Like schema_columns
On Jul 8, 2014 9:39 AM, "Kevin Burton" <bu...@spinn3r.com> wrote:
> Are there any easy/elegant ways to compare dev schema to production
> schema. I want to find if there are any rows/columns we need to add.
>
> I could try to format the output and just use 'diff' … but with the table
> options that isn't super clean either.
>
>
>
> --
>
> Founder/CEO Spinn3r.com
> Location: *San Francisco, CA*
> blog: http://burtonator.wordpress.com
> … or check out my Google+ profile
> <https://plus.google.com/102718274791889610666/posts>
> <http://spinn3r.com>
>
>