Hi,

I modified the sample data installer to try to update multiple databases.  I loop through DbeApplicationData and dbeConnectionsData to retrieve the database names and update the databases.

How can I pause the loop until a database finishes updating before moving on to the next?

<snippet>
     Do
       '-- do some stuff here.
       '-- then get to actual migration.

                            '-- Create the DatabaseMigrator instance
                            If _SQLUserName.Length = 0 Then
                                _DatabaseSetup = New DatabaseMigrator(connections.cs_server, True, Me, connections.cs_username, connections.cs_password)
                            Else
                                _DatabaseSetup = New DatabaseMigrator(_SQLServer, False, Me, connections.cs_username, connections.cs_password)
                            End If
 
                            '-- Begin the deployment of the meta-data (does not include the data in this phase)
                            _DatabaseSetup.DeployMetaData(_PackagePath & "\AES_AWAPPM.pkg", "", laDTNames)

'---I NEED TO PAUSE IT HERE TO WAIT FOR UPDATE TO FINISH BEFORE MOVING ON.

       Loop While connections.MoveNext()
</snippet>

I looked at the _DatabaseSetup_BuildComplete event.  But how can I tie that in to make it wait?


Thanks,

Marcel