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

Hi Greg,

The data structures will be the same.  The idea is that for single users to use VistaDB and for multi users then use MS-SQL Express.

I use the DDT for all my data design to take advantage of updating customer structure and data with DDT.  I have not try VistaDB yet, but will do so next week.

I also need to check if the RBS will work with VistaDB.  I will keep all my SQL commands as simple as possible to keep avoid database incompatibility, so will try to test everything in VistaDB first.  I have many single users with this application in VFP and VistaDB looks like a good alternative to MS-SQL in this case.

Edhy Rijo