StrataFrame Forum

Database creation tool

http://forum.strataframe.net/Topic23128.aspx

By Ian Hammond - 5/15/2009

Hi,

I am trying to write an application which allows a user to create a database, add tables and fields. The information gathered in the gui is saved in a predefined configuration table which is used to configure another gui allowing the user to add and view data in the created database. I have created a number of maintenance forms to allow me to enter data and save it to the 'configuration' table but I'm not sure where to start when creating the user defined database. Can this be done in the Application Framework  or do I need to interface to the DDT (which I haven't actually looked at yet). Could someone possibly point me in the right direction.

Many thanks.

By Trent L. Taylor - 5/15/2009

It sounds like you are trying to write your own version of the DDT.  The DDT is a database designer and deployment tool, which sounds like this is what you are trying to do.  However, the DDT doesn't have a supporting API at the moment which is what it sounds like you are needing.  From what I can tell you want to allow your users to create meta-data within your application then deploy that data for them.  At this point, you would have to create your own deployment engine as the DDT doesn't have an API or run-time desitner like the Role-Based Security to allow for this.

Depending on the complexity of your application and needs for database deployment, this can be a very long and cumbersome task.  But if you are going to travel down this path, I recommend using SMO (SQL Server Management Objects).

By Ian Hammond - 5/15/2009

I thought the DDT would come into it, it's a shame not having an api. Are there plans to produce one in the future?

Thanks for the pointer

Regards

By Trent L. Taylor - 5/15/2009

It has been discussed, yes.  But there is really not a high demand on this so it has not achieved a high priority.  But this is something that we have intended on for a while now.  However, this will most likely not happen this calendar year.