How can I export data from SimpleDB to Excel or TextPad?

I want to export data from SimpleDB to Excel or TextPad. How can I write a query for 开发者_如何学JAVAexporting data?

Thanks,

Senthil

You can use SDB Explorer to export the data into a CSV file, which you can open with your favorite editor.

Sdbport is a Ruby Gem that can export / import SimpleDB domains. It works across accounts and regions. It can be used as a class or stand alone CLI.

On a system with Ruby intalled (tested with 1.9.3p125):

Install sdbport:

gem install sdbport

Set your AWS credentials:

export AWS_ACCESS_KEY_ID=your_aws_key
export AWS_SECRET_ACCESS_KEY=your_aws_secret

Export SimpleDB domain from us-west-1:

sdbport export -a $AWS_ACCESS_KEY_ID -s $AWS_SECRET_ACCESS_KEY -r us-west-1 -n data -o /tmp/test-domain-dump

Import into domain in us-east-1

sdbport import -a $AWS_ACCESS_KEY_ID -s $AWS_SECRET_ACCESS_KEY -r us-west-1 -n data -i /tmp/test-domain-dump

You can Export your content of domain in XML using SDB Explorer. For more details please refer our documentation page and for watch video.

Disclosure: I'm a developer of SDB Explorer.