Sunday, March 28, 2010

Issues related to the deployment of data access application

Here are Some of the basic issues related to the deployment of the data access applications.

1)Can we suppose the required database exists at the target location?

2)If the database does exist then how can we get the connection string of it? Should we get it at the installation time? Or at the first run?

3)If the database does not exist then how it can be created? Is it the responsibility of human installing our application? Or the application should create it at the time of installation?

4)If the database is to be created by the application installation, then how does the installation setup know where (on which machine) to create the database? And what user name and password the setup should use to create the database?

5)Once, the database is created or its connection string is found at the setup time, then how to store the connection string for later use (regular execution)?

6)What if the database address (connection string) is changed during the application life cycle then what should be the application behavior? How can the application be aware of the new connection string?

7)If the database schema is hard-coded in the code (like table and field names) and the DB schema is changed (table/field name or data type is changed or new field/table added or some fields/tables deleted) because of any reason, then how to fix this problem?