StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Sample Data Installer Class

Sample Data Installer Class

Terry Bottorff — Wed, 19 Sep 2012 09:09:31 GMT

I am trying to use the "SampleDataInstallerClass" but the syntac for most of the statements are incorrect. Of course I am using one I found on the forum from a long time ago. Is there one later that will work with VS2010?

TIA.

RE: Sample Data Installer Class

Terry Bottorff — Wed, 19 Sep 2012 09:09:31 GMT

Cool. Great. Thank You.

RE: Sample Data Installer Class

Edhy Rijo — Wed, 19 Sep 2012 08:32:33 GMT

[quote][b]Terry Bottorff (9/19/2012)[/b][hr]That all makes sense but do you change the default location so when you use DDT it put the database where you want it or how do you make sure your data get's to the where you want it?[/quote]
Yes, I change the location so me and most important the customer knows where the database is located. DDT will either create or update the database based on the setup location in SQL Server configuration.

RE: Sample Data Installer Class

Terry Bottorff — Wed, 19 Sep 2012 08:24:34 GMT

Alright, thank you for the great explanation. That all makes sense but do you change the default location so when you use DDT it put the database where you want it or how do you make sure your data get's to the where you want it?

Also, the backup piece of software is great. Thanks........

RE: Sample Data Installer Class

Edhy Rijo — Tue, 18 Sep 2012 22:24:16 GMT

Hi Terry,

[quote][b]Terry Bottorff (9/18/2012)[/b][hr]If the database already exists will DDT honor where it is found?[/quote]
Yes.

Basically the rules is this, MS-SQL Server is responsible to handle the location of the databases (see attached image), the DBA or person in that role can configure the path where the database would be located, but a client application will not or should not even know anything about where the database file is located for security purpose, so the DDT has not way to create a database in a predefined path that may not even exist in the SQL Server.

What I normally do, is that since I am mostly the one to even install MS-SQL Express at the customer site, I create a data folder in the best drive possible and name it something like E:\MS-SQL Data Files, then at that point I let the customer know where the file is so they can do daily backups using the free program SQL Backup and FTP, this program is just a jewel because I can automate backups for up to 2 databases with free version and even upload the backup to an FTP site and get an email confirmation with status daily.

RE: Sample Data Installer Class

Terry Bottorff — Tue, 18 Sep 2012 14:19:12 GMT

I was talking about using DDT. Therefore, I just need to know where to tell the client to look for the Database when they run the program the first time.

If the database already exists will DDT honor where it is found or will it also put it in the SQL Server Instance pre-defined default database location?

TIA.

RE: Sample Data Installer Class

Trent L. Taylor — Tue, 18 Sep 2012 12:48:34 GMT

Are you wanting to know how to make a database end up in a certain directory when you create it through the DDT or if you are just restoring it using a BAK or reattaching an MDF? In the latter two, as long as the databases are local, you can specify any directory you want. When you create a new database through transact SQL, then you can use the "ON" command as part of the CREATE DATABASE:

[codesnippet]CREATE DATABASE database_snapshot_name     ON     (        NAME = logical_file_name,        FILENAME = 'os_file_name'     ) [ ,...n ] [/codesnippet]

Refer here for more details about the CREATE DATABASE:

http://msdn.microsoft.com/en-us/library/ms176061.aspx

If you are using the DDT, then no. It will use the SQL Server Instance pre-defined default database location when the databases are created. Hope that this helps.

RE: Sample Data Installer Class

Terry Bottorff — Tue, 18 Sep 2012 12:29:43 GMT

There are 2 projects in the solution. I changed the .Net on one of the solutions to 3.5 but not the other. Op's...... Now it Works.

But I still have the question, Is there a way to make sure that the database ends up an a particular subdirectory? If I copy the pkg to C:\test and run the Sample Data Installer Class on that pkg in that subdirectory is that where the Database will end up?

TIA.

And Thanks for the help on .Net 3.5 Version.

RE: Sample Data Installer Class

Terry Bottorff — Mon, 17 Sep 2012 17:17:06 GMT

I thought I tried that but I will have another look at it and let you know.

Thank you so much.

RE: Sample Data Installer Class

Trent L. Taylor — Mon, 17 Sep 2012 08:33:36 GMT

Terry:

The stack trace message is a fairly straight forward one. If you look at it, it is a .NET 3.5 / .NET 2.0 reference issue. StrataFrame is compiled in .NET 2.0 out of the box, but if you have downloaded the source, you can compile it for .NET 3.5, which you may have. There is nothing wrong with this, but you will need to make your downstream projects match the target version of .NET. For example, you sample project needs to be changed to a .NET 3.5 project if you leave it like this.

You can set the target version. In VB.NET, it looks like this:

You get to it through the Advanced Compiler Options:

Right click on your project
Go to Properties
Click on the Compile tab on the left
Click Advanced Compile Options at the bottom
Set the desired framework

In CSharp, it is actually easier to set.

Right click on your project
Go to properties
Click on the Application tab
You will see the target version right on the application page

RE: Sample Data Installer Class

Terry Bottorff — Sun, 16 Sep 2012 12:44:02 GMT

I have another question. Is there a way to control where the Database end up? In other words, can I direct it to a specific subdirectory?

RE: Sample Data Installer Class

Terry Bottorff — Sun, 16 Sep 2012 12:13:37 GMT

These are the Imports for This Project.

MicroFour.StrataFrame.Strings.StringBasics

MicroFour.StrataFrame.DBEngine

MicroFour.StrataFrame.DBEngine.SQL.SQLManagerEventArgs

But These are All of the Errors I am getting now. Ug.... Oh and by the way I am now trying to use the sample I found with my current version of SF 1.7

Error 6 'DatabaseMigrator' is notdeclared. It may be inaccessible due to its protection level.

1                    The primary reference "MicroFourStrataFrame DBEngine, Version=1.7.0.0, Culture=neutral,PublicKeyToken=99fe9917f71608a7, processorArchitecture=MSIL" could not beresolved because it has an indirect dependency on the framework assembly"System.Core, Version=3.5.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089" which could not be resolved in thecurrently targeted framework. ".NETFramework,Version=v2.0". Toresolve this problem, either remove the reference "MicroFour StrataFrameDBEngine, Version=1.7.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7,processorArchitecture=MSIL" or retarget your application to a frameworkversion which contains "System.Core, Version=3.5.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089".

2                    Error              3              Type 'DatabaseMigrator' is notdefined.

3                    Error              4              Type 'DatabaseMigrator' is notdefined

4            Error      5              Type 'DeployDataInfo' is notdefined.

Error     7              Type'MicroFour.StrataFrame.DBEngine.SQL.SQLManagerEventArgs' is not defined.

Error      8              Type'MicroFour.StrataFrame.DBEngine.SQL.SQLManagerEventArgs' is not defined.

Error      9              Type'MicroFour.StrataFrame.DBEngine.SQL.SQLManagerEventArgs' is not defined.

Error      10           Type'MicroFour.StrataFrame.DBEngine.SQL.SQLManagerEventArgs' is not defined.

Error      11           Type'MicroFour.StrataFrame.DBEngine.SQL.SQLManagerEventArgs' is not defined.

Error      2              Type 'SQL.DatabaseMigrator' is notdefined.

RE: Sample Data Installer Class

Terry Bottorff — Sat, 15 Sep 2012 13:58:55 GMT

I'll do that as soon as I get back to my machine. Thank you and I'll let you know what happens.

RE: Sample Data Installer Class

Edhy Rijo — Sat, 15 Sep 2012 12:19:16 GMT

Hi Terry,

Make sure you add the MicroFour StrataFrame DBEngine assembly to your project.

RE: Sample Data Installer Class

Terry Bottorff — Sat, 15 Sep 2012 11:28:36 GMT

As a follow up. These statements do not work.

Dim loDeploy As MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain

'-- Create the deployment form

loDeploy =

New MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain(lcPath & "StrataFrameSample.pkg", "framework")