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:

  1. Connect to a database by selecting an existing connection from the Connection list, or create a new connection by click the New button.
  2. All the available tables in that database are listed. Use the mover buttons to select the tables to import.
  3. Use the three Options checkboxes to indicate whether table names, column names, and indexes should be forced to uppercase when the tables are imported.
  4. At this point, you may click Finish to import all selected tables, or Next to go to the next page to refine the import.
  5. 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:
  6. 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.