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

Seems this would require the BO Mapper to be pointed to DDT for VistaDB, no? which you'd manage by hand but use for SQL Express ?



Or will BO Mapper allow you to see a VistaDB database if your connection string works?

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.

I only hope I could use the DDT for VistaDB since all my BOs are mapped to the DDT excepts for views which could be a problem between VistaDB and MS-SQL.  Will start testing next week with VistaDB and would like to hear from Trent or Dustin about any possible issues with this scenario and RBS compatibility issues.

Edhy Rijo