|
Follow the steps of this tutorial to upload database table's selected fields to
Amazon SimpleDB
, using
SDB Explorer
.
Follow the steps
to upload
database like MySql on Amazon SimpleDB:
-
Run SDB Explorer and connect with Amazon SimpleDB Account.
-
Click on "Upload" Button provided on tool bar.
-
A new panel will be opened.
-
Enter the appropriate values to their respective fields.
-
Check
Database Server
[1]
Type should be like com.mysql.jdbc.Driver.
-
Enter server name should be like jdbc:mysql://local host:3306.
-
Enter user name and password to get connected with database server.
-
Enter Database name from which you want to upload table.
-
Enter
Domain
[2]
name in which you want to upload structured data of your database, MySQL is one of the database from which we allow uploads, we will be adding more databases soon. If you enter the name that doesn't exist it will automatically be created.
-
Enter Query fetch size i.e. The size of the record to be fetched at a time.
-
Enter
Query
[3]
as select * from doc_name that is to be executed and to be uploaded on Amazon SimpleDB. Here doc_name is a table name in database.
-
Click on Execute button.
-
You can enable/disable “Sort by Item-Name” feature. If you want to disable this feature for domain then uncheck the option. By default this feature remains enabled.
-
After executing the query your fields will be visible in the
Field Name
column.
-
Select fields that you want to upload.
-
Along with Field Name column there are two more columns
ID Field
and
Replace.
-
Check any ID Field with respect to Field Name. This is optional to check.
-
If you check any ID Field then that Field name will be considered as an Item-Identifier for Uploaded data to Amazon SimpleDB. This Field will be containing unique values on Amazon SimpleDB and rest field values will be sorted accordingly. This facilitates user to select his/her own ID field as an Item-Identifier.
-
Check any
Replace
with respect to
Field Name
. This is optional to check.
-
If you check any
Replace
check box then on uploading, the value of
Field Name
will be replaced from the existing value(s) in case if Items-Identifier is same for this Field name. This facilitates you to either add or replace value(s) when Attribute-value pair already exists for a given item.
-
Click on upload button to upload Data.
-
After completion of uploading, SDB Explorer will display all the uploaded records automatically.
|
-
^
Database Server
: A database server is a computer program that provides database services to other computer programs or computers.
-
^
Domain
: A domain is like a spreadsheet or table with items in rows, attributes in column's header, and values in cells. A domain is composed of items, and items are described by attribute-value pairs.
-
^
Query
: A specific request given with Select key word for information retrieval from database. If you want to show entire fields then enter Select * from <table> or specify field instead of * to show desired fields in records.
Related Topics
:
|
|
|
