Import Tables wizard
This is a feature of JBuilder Professional and Enterprise.
Use the Import Tables wizard to import data from another database
into the current JDataStore. The connection and SQL statement used for
importing are saved, so that you can refresh the data when desired. You
can also edit the data in the JDataStore Explorer, and resolve those
changes back to the original database.
You may import data from one or more tables using the following steps:
- Connect to a database by selecting an existing connection from
the Connection list, or create a new connection by
click the New button.
- All the available tables in that database are listed. Use the mover
buttons to select the tables to import.
- Use the three Options checkboxes to indicate whether table names, column names, and indexes should be forced to uppercase when the tables are imported.
- At this point, you may click Finish to import all
selected tables, or Next to go to the next page to
refine the import.
- The second page lists each table to be imported, with a simple
SELECT *
SQL statement to import all fields from all rows.
You may edit:
- The Store Name to use for the imported data;
that is, what the name of the table will be inside the JDataStore.
You may include JDataStore paths with the
/
symbol.
- The SQL statement that describes the data.
Clicking the cell opens a simple text
edit dialog box.
- Whether to Create Indexes for the imported
table. The existing indexes for the table in the source database
will be recreated in the JDataStore.
- Whether to Enable Refresh for the table from
the Tools menu.
- Whether to Enable Save for the table from the
Tools menu.
- When you have refined the imports, click Finish to
import the data, or Back to go back to the first page
and choose different tables or a different connection.