Hi all, I'm new to the world of StrataFrame & was wondering if its possible to use a VistaDb v3 database (since is self contained & managed).



I saw a post about it somewhere but wanted to know if the "Businesss Object Mapper" would work with it?



If it dosen't, would it still work if I wrote the Business Objects by hand?



(More likely I would write a script gen using MyGeneration, did this for Opf3 & Xpo)



I also noticed that you get the source code when you purchase, does this include the "BOM"?



Is anyone else using StrataFrame with VistaDb 2/3?



Cheers,

Joel

Joel,

Is there anything preventing you from using SQL Server in your environment or do you just have a preference to VistaDB?

Hi, I use sql server for larger projects where I know there will be a data server & lots of clients.



I use vistaDB for small programs (1-2 users) & where the database needs to be portable (e.g. easily zipped & emailed to me or copied from one machine to another).



I don't like MS access for the file bloating (especially over a shared network) although MS access does have its used (e.g. XPO can auto generate & databases & update schema which is cool for small single user projects).



I am currently looking into Sql Everywhere to see if its possible to use this & syncronized databases without a sql server.



I like using vistaDB because I can programatically update the schema & syncronize very easily.



Cheers,

Joel

Hi, I use sql server for larger projects where I know there will be a data server & lots of clients.



I use vistaDB for small programs (1-2 users) & where the database needs to be portable (e.g. easily zipped & emailed to me or copied from one machine to another).



I don't like MS access for the file bloating (especially over a shared network) although MS access does have its used (e.g. XPO can auto generate & databases & update schema which is cool for small single user projects).



I am currently looking into Sql Everywhere to see if its possible to use this & syncronized databases without a sql server.



I like using vistaDB because I can programatically update the schema & syncronize very easily.



Cheers,

Joel

This is the entire purpose of our Database Deployment Toolkit and the DatabaseMigrator class.  It allows structures (and data) to be easily deployed to SQL Server without any scripting!