Are you using a framework that supports multiple backend databases? This is the best way I can think of to make your application capable of switching databases even dynamically.
Tim
>Hi
>
>I wish to design my .NET app to be portable to multiple databases such as MYSQL, Oracle, MSSQL
>
>May I know which of the following strategies is best in terms of flexibility and ease of delivering maintenance updates to clients:
>
>1. Use Store Procedures
>2. Use Views
>3. Use SQL stored in some user defined tables with following fields
> a. DB_Type
> b. SQL_ID
> c. SQL Command
>
>Your advice much appreciated.
>
>Best Regards
Timothy Bryan