StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Deploying package into many databases resided in the same server

Deploying package into many databases resided in the same server

Luiz Lima — Mon, 09 Nov 2009 15:55:01 GMT

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

RE: Deploying package into many databases resided in the same server

Luiz Lima — Mon, 09 Nov 2009 15:55:01 GMT

Keith,

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

See ya!

RE: Deploying package into many databases resided in the same server

Keith Chisarik — Mon, 09 Nov 2009 14:15:32 GMT

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.

RE: Deploying package into many databases resided in the same server

Luiz Lima — Mon, 09 Nov 2009 12:13:50 GMT

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

RE: Deploying package into many databases resided in the same server

Keith Chisarik — Mon, 09 Nov 2009 08:41:44 GMT

Check out the DatabaseMigrator class on these forums, it is actually pretty easy to automate this.