Deploying to database

System

Is it possible to deploy content to database using Perl scripts without using Datadeploy?

Find more posts tagged with

Comments

Migrateduser

what kind of content are we talking about, Metadata, DCR's or XML.

Adam Stoller

Yes, it is possible - using PerlDBI - but you might find yourself having to write a lot of code that comes built-in with DataDeploy:
(1) extracting the desired information to be deployed
(2) connecting to the database
(3) creating / updating / deleting table entries
etc.

So - yes, it's possible, but I wouldn't consider it unless you have decent experience working with databases at this level (or can get sufficient time/assistance from your local DBA).

--fish
(Interwoven Senior Technical Consultant)

s6634

Using Perl's DBI/DBD modules, you can deploy to the database. This one is pretty easy to do.

Migrateduser

does it require lot of perl coding(to simulate all the functionality that is out-of-the-box with datadeploy)? Does DataDeploy support many-to-many relationships?

Migrateduser

Yes definitely it will take a lot of coding to simulate DD functionality.
DataDeploy does support many-many relationships

Migrateduser

I recommend using DataDeploy 5.6 if you need to support many-to-many relationships in your deployments.

Todd Scallan
Senior Product Manager
Interwoven
t: 408-530-7167
e: tscallan@interwoven.com