How to Upload MY SQL Data by Specifying Your Own Field as an Item Name Using Amazon SimpleDB ?

Follow the steps below to upload MY SQL Data by specifying your own field as an item name:

1. Run SDB Explorer as Usually.
2. After successful login, select any domain of any region end point from the tree on lefthand side corner.
3. Click on Bulk Upload button from tool bar of main window.
4. Select Upload MY SQL Data from drop down window. A new upload panel will be opened.
5. Connect using the saved connections that you added in Add/Manage Database Connection .
6. After sucessfully connected, Enter Database Name from which you want to upload table or select it from the list shown when clicking on "Select" hyperlink.
7. Enter Table Name or select it from the list shown when clicking on "Select" hyperlink.
8. Enter Domain name in which you want to upload data of your database.
9. Select server region end poin t for the specified domain name.
10. Enter Query fetch size i.e. the size of the record to be fetched at a time .
11. Enter Query as select * from <table name> that is to be executed and result of the query will be uploaded on Amazon SimpleDB. Click on Execute button
12. A label situated over left hand side corner of Execute button, will show number of records to be uploaded from database.
13. After executing the query your database fields will be listed in the Database Fields column.
14. Select fields that you would like to upload.
15. Select the field which is primary key in the database table.
16. Click on Advance hyper link situated over bottom of the panel at left hand side corner. A new panel will be opened.
17. Select Consider other data base filed as an Amazon Simple DB item name radio button.
18. Select any field from dropdown, other than Primary Key.
19. An Advance panel will be disposed, now hit Upload button.
20. A new ADD/REPLACE panel will be opened, now without any change hit on Ok button.
21. If batch gets success then success count updated, if batch gets fail then fail count  updated.
22. After queue processing gets over, double click on domain in which you have uploaded.
23. The number of rows that has been uploaded successfully will be shown in GRID.