I am venturing out and I want to try to use the SampleDataInstallerClass. I have run the sample that is out there and it works good with the Strataframe sample data. Now I want to try it on my database and tables.

The database path is configured in SQL Server using SSMS, I am not sure you can change that programatically, but try searching in Google, there may be a script or something that allows you to set that up.

Edhy Rijo

Many of my users have SQL Express installed but not SSMS. I just wanted  to put the Data Base somewhere easier to find. I'll check Google. Is there Anything else I should look out for using this class?

I found this on Google but have not tried it.

Hi Terry,



Well, I would say, do a lot of testing with dummy database, until you feel comfortable with the process.  When I started using SF I also was fairly new to MS SQL, so understanding the whole thing and decoupling from Visual FoxPro took some time.  I have been able to modify the installer class to suit my needs and I am very happy with the outcome,  still have a thing or two that I need to review, fix and test, but it is working.

As for the database location, this could get tricky since in most of the cases your database may be the only one SQL instance used by your customers, but in come cases, customer may already have SQL Server installed with other databases, so programmatically changing the default database location could be rude, so I simply let SQL Server do its job and place the data files wherever they are setup to be placed.  I have some customers with MS Small Business Server OS which already comes with SQL server license and a whole bunch of databases.

I always build my applications in the less obtrusive mode, so when they are installed/uninstalled, it should not affect the OS at all and the end user will be happy and of course, less support calls.

Edhy Rijo

Great ideas. Thanks. I am just plugging away and everyday is something new and I just keep chugging.

Alright.