Export AS/400 database to new website

25 pts.
Tags:
AS/400 administration
AS/400 database
AS/400 database administration
how would we go about exporting our as400 product database of 2,000 items (without images - only image name or link) to our new website?  we would likely be using a Joomla content management system (CMS) website but would use standard HTML if we had to.

Software/Hardware used:
as400, dreamweaver, joomla
ASKED: May 17, 2011  1:51 PM
UPDATED: May 18, 2011  11:13 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Mariodlg
    Your question envolves a lot of technical things. I think you should be more specific and segment your initial question in many others, by example: It is the same database structure? Are you using a marketing joomla plugin and do you want your data matches joomla's database structure? What is the As400 server rol in this case? it is only database server? I have a lot of questions, but maybe you prefer to rewrite your question, so we can help you better.
    2,790 pointsBadges:
    report
  • Sjames0077
    The as400 is database only server. Would use marketing joomla plugin if it was recommended ... yes data to match structure, I assume.. Sorry don't know much more technical on this .. kind of need a kick start in the right direction
    25 pointsBadges:
    report
  • Mariodlg
    Ok, first you need to know if the database structure is the same in both servers, if so then you can do a data dump or export to a text file using a program like DBVisualizer or similar. The resulting file has commands for database recreation and the insert commands to write your data too, in this way you only need to run the commands in the other database to recreate your database. If your database structure is not the same then you need to write a program to do the migration of data doing the right thing to save the data in the correct way. This task is for a programmer. If you database structure is not the same, you need to know the database structure and system functionality to work in the website design like the last one task. Other way is if your database structure is the same then you need to change only database connection parameters to your joomla installation and then you will have your new website up and running. Hope these few lines helps you a little more.
    2,790 pointsBadges:
    report
  • Sjames0077
    yes they do clear things up a bit, thanks.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following