SimpleDB Import Tool
The Amazon SimpleDB import tool provided by RazorSQL allows users to easily import data into SimpleDB databases. The following import options are supported:
- Delimited Files: delimited files such as comma separated (csv), tab separated (tsv) space separated, and any other type of delimited file.
- Excel Spreadsheets: the SimpleDB import tool can automatically read and import data from Excel spreadsheets into SimpleDB domains.
- SQL Insert Statements: the import tool can read SQL statements from a file and execute them against the SimpleDB database. This is provided the insert statements follow the SQL syntax standards supported by the RazorSQL SimpleDB database driver.
The SimpleDB import tool prompts the user for information about the domain for which to import the data and the way in which the attributes match up to the imported data. The import tool can then execute the import, or generate the SQL insert statements necessary to perform the import.
The SimpleDB data import tool allows users to specify whether or not to halt on error. Users can also choose to not actually update the data, but instead write the generated SQL insert statements to an output file for later execution.
For more information on the SimpleDB import tool, see the following documentation:
Import Tool Documentation
RazorSQL also offers many other Amazon SimpleDB tools such as a SimpleDB database browser, GUI tools for managing SimpleDB domains and attributes, and much more. See the main SimpleDB Features Page for more information.