Hi! I'm building a commerical product that needs to target multiple databases depending upon what the client already has installed. Some of my clients will have Oracle, others MS SQL, etc. Each would only use a single database per installation and the database design would be the same in all cases (ie. same tables, same relationships, etc.) Furthermore, I'd be sure to never utilize database-spefiic features like CLR-based code.

Is the above possible? If so, is there a working example of this or at least good docs?

Hi, yes is possible and actually very simple to implement, there are tons of information regarding that subject in our forum threads, see the following as an example: http://llblgen.com/tinyforum/Messages.aspx?ThreadID=12171, or search for other similar threads in the search of the forum using the keywords multiple databases.

Thanks for the encouraging answer! Unfortunately, the link didn't work...

http://llblgen.com/tinyforum/Messages.aspx?ThreadID=12171