RE: Deploying a PackageIt file

Trent L. Taylor — Wed, 01 Nov 2006 15:06:20 GMT

That is when you will want to use the Option 2 mentioned above.

RE: Deploying a PackageIt file

Vikram Saxena — Wed, 01 Nov 2006 15:03:18 GMT

Is there any method of deploying on SQL Servers remotely located for web applications. I definitely cant install DDT on the database server.

RE: Deploying a PackageIt file

Trent L. Taylor — Wed, 01 Nov 2006 15:02:06 GMT

At first glance I am not seeing this. It must have been left out of the compile help file. We will get this addressed :blush: sorry for any trouble.

RE: Deploying a PackageIt file

Vikram Saxena — Wed, 01 Nov 2006 14:18:02 GMT

Hi,

Thanks. are these options documented in the DDT Help File ?

RE: Deploying a PackageIt file

Trent L. Taylor — Wed, 01 Nov 2006 13:17:33 GMT

There are three ways to deploy your package. Below are each of the options.

Option 1
Deploy your package file through the DDT run-time environment. See the image below for a point of reference.

Option 2
This option is geared more towards installations. You can programmatically deploy a package using the a class that may look something like this:

Imports MicroFour.StrataFrame.DBEngine.SQL

Public Class SetupMenu

''' <summary>
''' Declare the variable with events so that we can capture progress indicators
''' </summary>
''' <remarks></remarks>
Private WithEvents _DataDeploy As DatabaseMigrator

''' <summary>
''' Deploy the data to the specified server
''' </summary>
''' <remarks></remarks>
Private Sub DeployData()
'-- Create a new migrator instance
_DataDeploy = New DatabaseMigrator("localhost", False, Me, "sa", "mypassword")

'-- Deploy the structure to the SQL server
_DataDeploy.DeployMetaData("c:\MyPackageFile.pkg", "")
End Sub

''' <summary>
''' Captures any detailed information about the progress of the deployment
''' </summary>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub _DataDeploy_ProgressUpdate(ByVal e As MicroFour.StrataFrame.DBEngine.SQL.SQLManagerEventArgs) Handles _DataDeploy.ProgressUpdate
Me.ProgressBar.Value = e.ProgressPercent
Me.lblTitle.Text = e.Title
Me.lblMessage.Text = e.Message
End Sub

Private Sub SetupMenu_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.GotFocus
'WinAPI.SetForegroundWindow(Me.Handle.ToInt32())
'Me.BringToFront()
WinAPI.BringWindowToTop(Me.Handle.ToInt32())
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
MenuSystem.UDPMenuSession.SendMessage(UDPMessageType.VisualFoxProCommand, Me.Textbox1.Text)

End Sub

End Class

Option 3
This is similar to Option 2, but you do not have to use your own dialogs. You can use the same dialogs that you see witin the DDT run-time environment. This is how you would call them.

Dim loDeploy As New MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain("c:\MyPackage.pkg", "")

loDeploy.ShowDialog()

Deploying a PackageIt file

Vikram Saxena — Wed, 01 Nov 2006 11:03:06 GMT

I am quite new to DDT so pls pardon my lack of knowledge on DDT. I have made a DDT Package-IT File, but am not able to figure out how to deploy on SQL 2000 database on my client's server using the Package-IT file.

StrataFrame Forum / StrataFrame Database Deployment Toolkit / Database Deployment Toolkit (How do I?) / Deploying a PackageIt file / Latest Posts

RE: Deploying a PackageIt file

RE: Deploying a PackageIt file

RE: Deploying a PackageIt file

RE: Deploying a PackageIt file

RE: Deploying a PackageIt file

Deploying a PackageIt file