[EMAIL PROTECTED] wrote:
Hi,

Is there any way to configure the psml importer so that it will generate
sql scripts instead of updating live the database?
No, not really.
Because Jetspeed needs to support many different databases which use different 
sql formats, we actually are moving away from providing/generating sql...
The only transportable solution we have is using intermediate xml and push/load 
that using a jdbc connection.

I do understand your problem though, but I don't see an easy, generic and 
transparent solution for this.
If you really need plain sql scripts, the only option I see right now is initial loading a developing database using the psml importer, and then use a data dump tool/task usually provided with your database to generate the sql scripts. But, if you can come up with a generic tool/solution for that which we can integrate/provide (e.g. ASF license compatible) with Jetspeed, I'd be happy to investigate/review that.

Regards,

Ate


Here in my project, we are planning to use Jetspeed to create our new
corporate portal. Jetspeed is fine for what we are trying to do but there
is one point where I am not sure of the best solution.

We are planning to develop the portal using xml psml files and migrate to
the different environments by importing the psml into the database. While
this is fine, the corporate habits here are to never use a program to
update a database and prefer to generate sql scripts, that you can review,
to do the populate job.

If it is not supported, what would be the best and easiest way to implement
that feature? It is important enough for our project to implement this here
if necessary and I consider seriously contributing back.

Thanks,
Seb


This message and any attachments (the "message") is
intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified.
                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales) decline(nt) toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to