StrataFrame Forum

Deploying package into many databases resided in the same server

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

By Luiz Lima - 11/9/2009

Hi guys,

I have a lot of customers using the same server and i´d like to deploy automatically the whole db changes (including profile scripts) to all databases inside the server.
This can be occurs with a new database also.

If I do it using DDT Deploy Button, changing the database name, the system rename the database and create another file with MDF extension.
I know that it´s the a DDT concept, but i´d like to know how can I do that automatically without rename.

See the attached images.

Tks

Luiz

By Keith Chisarik - 11/9/2009

Check out the DatabaseMigrator class on these forums, it is actually pretty easy to automate this.
By Luiz Lima - 11/9/2009

Keith,

The ClassMigrator will be update my schema processing the whole packages?
I understood that ClassMigrator would copy my data from database to another.
I´d like to process packages selectively:

- tables, indexed, triggers, scripts and etc

Tks

By Keith Chisarik - 11/9/2009

The DatabaseMigrator class allows you to programatically apply DDT packages to one (or more) databases. I think this is what you are asking, there is a nice sample in the SF help.
By Luiz Lima - 11/9/2009

Keith,

Tks.. As soon as possible I´ll try do write a program based upon the SF example.
If I have problems, i scream! BigGrin

See ya!