|
Deploying the database in a different format
You can develop your application using one database format and deploy it in another database format. For example, you might develop your application using a Microsoft Access database to take advantage of that format's portability, then deploy it with a Microsoft SQL Server database.
When deploying a database in a different format, keep in mind the following requirements:
 |
The structure of the deployment database must be identical to the structure of the prototype database. For example, in the new database the number of tables and table columns—and their names—must be identical to those in the prototype database. |
|
A database driver supporting the new database format must be installed on the server hosting your application files. |
|
The DSN or connection string used to connect to the database must specify the new database driver. |
Finally, make sure the SQL expressions in your dynamic pages are correctly interpreted by the new database. Some database vendors have slightly different implementations of SQL.
| 
