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'm guessing that the ODBC connection would work in BO mapper with VistaDB. However, you could always just use the SQL Server version to get the mapping done, since they have to have the same table/column names.



As to deployment, DDT would work for the SQL server variety, but I believe you're on your own for VistaDb.