I don't know if this is possible or not with the BO, but I need to design an application that can be used with different database like VistaDB and MS-SQL.



The idea is that there will be customers that will use VistaDB mostly for single users and others will use MS-SQL for multiple users. Can a BO be setup to connect to either database? How?



P.S.

My understanding is that VistaDB database is pretty much compatible with MS-SQL TSQL language, they do not support all the features of MS-SQL of course, but at least it looks like they support all the standard features and if that is the case, then it may work for my project.

Edhy Rijo

I'll bet you won't be able to use DDT with Vista DB unless it exposes an SMO object model that is identical to SQL Server and that seems really unlikely.



But the rest of it sounds pretty smooth.



(don't know about RBS of course)