1. Deploy my application with both a sample database and an empty database
2. Allow user to create new databases based on the structure of the the deployed database.
I have created a DDT profile and imported a database that I already had in SQLExpress. I used the "Import Database" feature. I figured this would import that metadata but found that it also imported all the records. The help file mentioned that it imported the structure but did not mention that it also imported the records. Did I miss an option? I suppose that i could use that as my sample database.
Deployment: How do I deploy both this sample database (with all datas records) as well as allow the end-user to create one or more databases based on the structure of the sample database? I will be using InstallAWare to create the install script. Do I deploy the sample database to the database server via my install script and then let the user open that sample company or create a new company based on that metadata? Or can the end-user deploy both the sample data asnd create database via a StrataFrame dialog included in my applicaition using the DDT Deployment package?
Sorry for all the basic questions. I know some of these may be answered here already but i need a step by step deployment guide all in one place to get me started.
At the moment, you cannot change the database name when you deploy a package. In other words, if the database name is "MyDatabase" in the DDT package, you cannot rename it to "MyDatabase2" when it deploys. However, this will change in the near term as we have had this requested many times and is something we need ourselves. However, if you are referring to just swapping a connection string, this is very easy and this support already exists.
As for the sample, if you will read the last post I made, it will have the link to the sample to get you going. or just click this link: http://forum.strataframe.net/Topic4635-17-1.aspx