StrataFrame Forum

Stand alone install?

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

By Keith Chisarik - 4/6/2007

I don't see the DDT standalone install under my download section, where can I get it please? I need to install DDT at a customer site that does not have Visual Studio installed to do a deployment of a database today.



Thanks.
By Ben Hayat - 4/6/2007

Hi Keith;



That's a good point and I had thought about it, but I'm not sure we are allowed to install DDT at customer site. I "think" it's meant to be used in your system to create a deployment/installation package.



However, I can see the need [for myself soon], to install DDT on a tester site, in order to make changes to database.



Let's hear it from the boys!
By Keith Chisarik - 4/6/2007

I know it is "allowed" because Ben said it was OK yesterday Smile



I would still like to be able to have access to standalone DDT install BUT, not having it available nudged me to take the 10 minutes it took to include package deployment as a menu option in my application.



All I added was a menu item with the following code (and added a PW to my package file to keep silly customers out)



'-- Establish Locals

Dim appPath As String



appPath = System.Windows.Forms.Application.StartupPath

MsgBox("apppath")



Dim lcPath As String = AddBS(appPath) & "metadata"

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



'-- Create the deployment form

loDeploy = New MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain(lcPath & "la_rpm_.scan_db.pkg", "")



loDeploy.ShowDialog()

loDeploy.Close()

loDeploy.Dispose()
By Keith Chisarik - 4/6/2007

gotta love cut and paste from the sample application Cool
By Ben Hayat - 4/6/2007

I know it is "allowed" because Ben said it was OK yesterday




I didn't say that yesterday...BigGrin (j/k) I know which Ben you're talking about. But if that's the case, I think we should get an stand alone installation right from the web site.



SF, can we please...?
By Keith Chisarik - 4/6/2007

It used to be there, of that I am sure.



Either they bundled it in with the new install only (and I don't know how to install JUST the DDT) or it is missing.



I guess we shall see when the sun rises in Texas Smile
By Trent L. Taylor - 4/6/2007

Keith,

We no longer provide the DDT stand alone install as predominantly every one of our users were developers using the DDT over SQL administrators.  So it was axed since it was just one more installation to maintain.  As it sounds like you have already learned, it is very easy to create a .NET program to deploy your packages and is the "proper" way to deploy a database in the field Smile  This is why we provided the Database Deployment sample...which you found...and made it your own BigGrin

Just to explain a bit, the DDT stand alone install was NEVER designed with deployment in the field in mind.  That is why there is the DatabaseMigrator class.  If you think about it, this is exactly how we install the StrataFrame databases during an installation and this is how you should deploy to your customers.  That is why we provided the sample so you could see your options on how to do this.

By Keith Chisarik - 4/6/2007

OK. Like I said earlier this week "you cant fight the man".



I will miss is very much though, for making on site adjustments at my clients, now I will have to buy a real laptop I guess that will run VS2005/SF/DDT to accomplish this Sad


By StrataFrame Team - 4/9/2007

Sorry if I misspoke Keith... I thought your deployment scenario was that you were going to have the DDT installed on your computer and with remote access to the SQL Servers through TCP 1433 you would deploy from your DDT to their SQL Servers.  Each install of the DDT takes a license.  You can deploy through the MicroFour StrataFrame DBEngine.dll royalty free, but the DDT can't be deployed without a license.

Incidentally, the deployment dialogs within the DDT are included in the DBEngine.dll so you don't even have to write a UI... just a program that will call the MDDeployMain will get you there.

By Keith Chisarik - 4/9/2007

License are "per developer" though right?



If I decide I want to deactivate my license on my desktop to take DDT to a client site (or install to a "developer box" on site, that is OK right, so long I I deactivate when I am done?



My thought of a developer license is that so long as it is me doing it, I can do what I want, where I want?



You licensing model really doesn't allow for any exploit, but I still like to do things "by the book" if I have misinterpreted anything, please let me know.






By StrataFrame Team - 4/9/2007

Yes, technically, you could install the DDT on the client's site and then deactivate before you left the site... you can only have one install currently activated for a each license you have.
By Keith Chisarik - 4/10/2007

I am onsite at a customer right now having a major issue.

An install went bad, the application now has a "remembered" bad connections string, tries to use it and crashes when I try to run the app. It remembers the bad connection string even after I uninstall my application, where is this stored to I can delete it?

By Keith Chisarik - 4/10/2007

I found how to delete them, the problem now is that my app wont run far enough to run the DDT install methods since it is looking for SF "stuff" in the database that hasnt been deployed yet.

I am GREATLY missing the DDT Standalone install right now as all I can think to do is install VS,SF and deploy my package.

By StrataFrame Team - 4/10/2007

Hrm... yes the DDT requires access to the SF database or it will crash as soon as it starts up.  The standalone DDT install would be the same way; it would also require the StrataFrame database, too.  You'll have to either create a standalone app that uses the MDDeployMain to deploy the data or open up 1433 to your SQL Server so that you can reach it to open the DDT.
By Ben Hayat - 4/10/2007

Ben Chase (04/10/2007)
Hrm... yes the DDT requires access to the SF database or it will crash as soon as it starts up. The standalone DDT install would be the same way; it would also require the StrataFrame database, too. You'll have to either create a standalone app that uses the MDDeployMain to deploy the data or open up 1433 to your SQL Server so that you can reach it to open the DDT.




Ben, isn't it better that we just buy a copy of a stand alone DDT and put it on client machine? Can we then get us a stand alone installation, so it will become a straight forward installation?



Thanks!
By Trent L. Taylor - 4/10/2007

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.

By Ben Hayat - 4/11/2007

I think there is a misunderstanding as to what the stand-alone installation actually did before.




Hi Trent;



I had gone back and looked deeper into this and you're right. Sometime, when we come from other systems, we tend to think in the old fashion way (when I'm in TX, I'll show you how we used to have a DDT "Type" program at the design site and one at client site).



But it's good you make clarifications to these posts, so new users see the points already discussed!



Thanks!