Deploying a PackageIt file
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Deploying a PackageIt fileExpand / Collapse
Author
Message
Posted 11/01/2006 11:03:06 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 11/19/2007 4:06:18 AM
Posts: 41, Visits: 99
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.  
Post #4030
Posted 11/01/2006 1:17:33 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
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()

Post #4035
Posted 11/01/2006 2:18:02 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 11/19/2007 4:06:18 AM
Posts: 41, Visits: 99
Hi,

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

Post #4044
Posted 11/01/2006 3:02:06 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
At first glance I am not seeing this.  It must have been left out of the compile help file.  We will get this addressed   sorry for any trouble.
Post #4049
Posted 11/01/2006 3:03:18 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 11/19/2007 4:06:18 AM
Posts: 41, Visits: 99
Is there any method of deploying on SQL Servers remotely located for web applications. I definitely cant install DDT on the database server.
Post #4050
Posted 11/01/2006 3:06:20 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
That is when you will want to use the Option 2 mentioned above.
Post #4054
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 5:59pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 9 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.