Ben, isn't it better that we just buy a copy of a stand alone DDT and put it on client machine?
This thread has actually been a bit confusing to be to be honest. The DDT was never designed to be placed at a clients site. You are given all of the same tools, even the same deployment forms used within the DDT, within the framework and the database migrator class. This is shown within the Database Deployment sample.
The reason I am confused is on this point. If you are making changes to the end-users database outside of the same structure that is used to create your BOs, then your application and BOs are going to have to be recompiled in order to take advantage of the new structures. So if you are doing this at a clients site, you would also need to re-run the BO Mapper and recompile to actually take advantage of changing the SQL structures on site.
To deploy the databases that you have created at design-time, this is the point of the PKG (package file) and the DatabaseMigrator class....and the sample that we have provided showing you how to use the pre-built forms or one of your own.
So I still do not see the need for the stand-alone install. As mentioned above in Ben Chases post, you are going to have to setup the full StrataFrame database and re-import all meta-data in order for this to even be viable. In other words, you have to re-create the same development environment at your clients site as your development site in order for this to even work. So the ONLY reason would be to deploy a package, which you can create a stand-alone EXE or even use the same provided to create a facility to deploy PKG files outside of your application at a clients site.
we then get us a stand alone installation, so it will become a straight forward installation?
There is nothing straight forward about re-creating your development environment at each of your clients site as mentioned above. So I still do not see the need. I think there is a misunderstanding as to what the stand-alone installation actually did before.