Deploying a PackageIt file

Vikram Saxena — Wed, 01 Nov 2006 15:06:20 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.

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()

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Deploying a PackageIt file

Deploying a PackageIt file

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