StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Deployment Options for DatabaseMigrator class?

Deployment Options for DatabaseMigrator class?

Edhy Rijo — Fri, 06 Aug 2010 10:31:52 GMT

When using the DDT to deploy a package there are 3 Deployment Options available:
1- Standard Deployment
2- Deploy Stored Procedures, Views and UDFs Only.
3- Deploy Data Only

When using the DatabaseMigrator class, is there a way to provide a Deployment Option?

I have a customer with several million records and sometimes only a View or Stored Procedure changed, but the deployment will take over 30 minutes when using the DatabaseMigrator and I would like to programatically setup my update process to only update what have changed.

Thanks!

RE: Deployment Options for DatabaseMigrator class?

Ivan George Borges — Fri, 06 Aug 2010 10:31:52 GMT

Yep, you really could send a parameters file and work with it depending on your situations.

Glad the links helped. ;)

RE: Deployment Options for DatabaseMigrator class?

Edhy Rijo — Fri, 06 Aug 2010 09:55:28 GMT

Hi Ivan,

This post by Randy Jean [url=http://forum.strataframe.net/FindPost20066.aspx]http://forum.strataframe.net/FindPost20066.aspx[/url] really helps.

Since what I am trying to do is build an self automated update process so when I release an update to the customer, based on some parameters this will update the database and deploy needed data without user intervention.

In this case, this database could have several million records and hence the need for me to control how the DatabaseMigrator class should apply the update, but I am having some problems figuring out how to let the DatabaseMigrator do their job automatically, probably using an encrypted XML file in the same folder as the DDT package file.

Anyway, thanks again for the prompt assistance and comments.

RE: Deployment Options for DatabaseMigrator class?

Ivan George Borges — Fri, 06 Aug 2010 08:20:10 GMT

You're welcome, my friend. :cool:

RE: Deployment Options for DatabaseMigrator class?

Edhy Rijo — Fri, 06 Aug 2010 08:01:55 GMT

Thanks Ivan.

RE: Deployment Options for DatabaseMigrator class?

Ivan George Borges — Fri, 06 Aug 2010 07:57:34 GMT

See if this ones help:

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

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

RE: Deployment Options for DatabaseMigrator class?

Edhy Rijo — Thu, 05 Aug 2010 16:56:25 GMT

Ivan,

If you don't mind can you post a VB sample code on how to create the collection for the DatabaseTargetName?
[codesnippet]
_DatabaseSetup.DeployMetaData(_DDTPackagePathAndName, _DDTPackagePassword, DatabaseTargetName, True)
[/codesnippet]

RE: Deployment Options for DatabaseMigrator class?

Edhy Rijo — Thu, 05 Aug 2010 16:30:12 GMT

Thank you Ivan.

I didn't notice the overload, I was using this code only:
_DatabaseSetup.DeployMetaData(_DDTPackagePathAndName, _DDTPackagePassword)

Now for the DatabaseTargetNames, I have to create a string array with the names of the database I want to create? usually will be just one name.

RE: Deployment Options for DatabaseMigrator class?

Ivan George Borges — Thu, 05 Aug 2010 15:38:57 GMT

Hi Edhy.

Have a look at the DatabaseMigrator.DeployMetaData overload:

public void DeployMetaData(
string MetaDataPkgPathAndFileName,
string PkgPassword,
DatabaseTargetName[] DatabaseTargetNames,
bool sprocsViewsUdfsOnly)

Public Sub DeployMetaData ( _MetaDataPkgPathAndFileName As String, _PkgPassword As String, _DatabaseTargetNames As DatabaseTargetName(), _sprocsViewsUdfsOnly As Boolean _)

public:void DeployMetaData(String^ MetaDataPkgPathAndFileName, String^ PkgPassword, array<DatabaseTargetName^>^ DatabaseTargetNames, bool sprocsViewsUdfsOnly)

Parameters

MetaDataPkgPathAndFileName (String): The path and filename of the package file containing the metadata

PkgPassword (String): The password for the package file

DatabaseTargetNames (array< DatabaseTargetName >[]()[]): A collection of target database names. This allows the database name to change dynamically from what is within the package file at run-time.

sprocsViewsUdfsOnly (Boolean)