How to Upload MY SQL Data by Specifying Primary Key as an Item Name Using Amazon SimpleDB?

Follow the steps below to Upload MY SQL data in your domain :

1. Run SDB Explorer as usual.
2. After successful authentication, select any domain of any region end point from the tree on left had side corner.
3. Click on Bulk Upload button situated over tool bar of main window.
4. Select Upload MY SQL Data from drop down window.
5. Connect using the saved connections which you have 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 point for the specified domain name.
10. Enter Query fetch size i.e. The size of the record to be fetched at a time by the database.
11. Enter Query as select * from table_name that is to be executed and to be uploaded on Amazon SimpleDB. Here table_name is Table Name you Entered.
12. Click on Execute button.
13. You can see number of records to be uploaded from database by a label situated over left hand side corner of Execute button.
14. After executing the query your database fields will be listed in the Database Fields column.
15. Select fields that you would like to upload.
16. Select the field which is primary key in the database table.
17. Hit on Upload button.
18. A new ADD/REPLACE panel will opened and without any change , hit on Ok button.
19. After some time a queue will be opened and the uploading process will start.
20. You can see uploaded data after queue processing gets over, by  double clicking on domain in which you have uploaded.