Upload MY SQL Data Using Auto-Generated Item Name

Follow the steps to upload database like MySql on Amazon SimpleDB with Auto-Generated key:

1. Run SDB Explorer as usual.
2. After successful login, select your domain from the tree.
3. Click on Bulk Upload button present at tool bar of main window.
4. Select " Upload MY SQL " Data from drop down window.
5. Connect using the saved connection 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 point for the specified domain name.
10. Enter Query fetch size which is The size of the record to be fetched at a time by 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. After executing the query your fields will be visible in the Field Name column.
14. Click on "Advance Settings" hyper link situated over bottom of the panel at left hand side corner.
15. A new panel will be opened.
16. Select radio button named as "Generate Auto numbers for each row a Amazon Simple DB item name" .
17. Provide starting Number i.e. from where you would like to start generating numbers.
18. Providing prefix, It is optional.
19. Click on Ok button.
20. From ADD/REPLACE panel open select check box "Select All" or "Replace All" as needed and Click "Ok" button.
21. Now click on Upload Button.
22. After completion of uploading, explore the specified domain. You will find uploaded data in GRID.