Incorporating Database Changes in Your Application

Implement database changes using Iron Speed Designer's refresh feature. Refreshing your database tables allows Iron Speed Designer to rebuild your application using the updated database tables.
- Alan Fisher, Chairman of Iron Speed, Inc.

September 13, 2005
Iron Speed Designer V3.0

Updating Database Schemas for Your Application

When you change the underlying database tables upon which your application is built, you need to inform Iron Speed Designer of these changes so that Iron Speed Designer generates code matched to your updated table schemas. You can do this using Iron Speed Designer's refresh feature. Refreshing your database tables allows Iron Speed Designer to rebuild your application using the updated database tables.

The table below shows the database modifications that require refreshing database schemas to your application.

Adding Renaming/Changing Deleting

Table

Primary Key

Table Fields

Table Field Type

Table Field Size

Default Field Value

Foreign Key Relationship

Refreshing a Database Schema to Your Application

Select Tools, Database Schema, Scan All Tables for Changes

The database is searched for tables that may require refreshing due to changes in the underlying table definitions. Those tables requiring refreshing are marked in orange in the Databases folder in the Application Explorer.

Select Accept All Changes or Accept Changes for Selected Table.

This performs the actual refreshing of the tables highlighted in the tree. This gives you the opportunity to de-select any tables you do not wish to refresh.

The refreshing process is performed and confirmed. Your application will now incorporate the new database changes the next time you build your application.

Mapping Fields

If it is likely that a database field was renamed, the Map Field function can be used to identify the old field currently used by Iron Speed Designer and its renamed counterpart in the database schema. By mapping the old field to the new one, you can retain previously entered table and page properties.

Deleting Tables from Your Database

Because Iron Speed Designer is not a database schema-editing tool, you cannot add, edit or delete database tables in Iron Speed Designer.

Renaming Your Database

Iron Speed Designer cannot detect when you've renamed your database. To modify your application to use a renamed database, change your database's name in your application's Web.config file. This will preserve all the changes you have made to the application as the application is essentially pointing to the same database but with a different name.

About the Author

Alan S. Fisher
Co-Founder and Chairman of Iron Speed, Inc.

Mr. Fisher was a General Partner at Outlook Ventures, Inc., a venture capital company prior to co-founding Iron Speed, Inc. He co-founded Onsale, Inc. (now Egghead.com) and was its Chief Technology Officer from July 1994 to December 1999. He also Co-founded and was President of Software Partners, Inc, a developer and publisher of software products from August 1988 to July 1994. From April 1984 to August 1988, Mr. Fisher served as Technical Marketing Manager and Product Development Manager for Teknowledge, Inc., a developer of artificial intelligence software products. From June 1981 to April 1984, he served as a member of the technical staff for AT&T Bell Laboratories. Mr. Fisher serves on the Board of Directors of Infodata Systems Inc. (NASDAQ:INFD) an e-business consulting services company; He formerly served on the board of a number of companies including Onsale, Inc. (later Egghead.com and now Amazon.com), and FatBrain, Inc. an Internet retailer of technical and professional books.

Mr. Fisher received his B.S. in Electrical Engineering from the University of Missouri and received his M.S. in Electrical Engineering from Stanford University.



	Copyright © 2005-2008, Iron Speed, Inc. Iron Speed® is a registered trademark. All rights reserved.	Privacy Statement