Return to Jive Software

Up to Discussions in Jive Forums
728 Views 4 Replies Last post: Oct 27, 2009 6:13 PM by Karl Cyr RSS
erichendrickson Novice
erichendrickson
33 posts since
Jul 14, 2009
Currently Being Moderated

Oct 8, 2009 9:09 AM

Database Migration methods?

Hello,

 

Our Test and Production environments are being built on Oracle, however we have a small "POC" environment running on Postgres where some of our business users have made some look-and-feel changes to the environment.  And going forward, we may want to migrate some data from environment to environment (Oracle to Oracle).  I have the following questions:

 

  1. The POC is running Jive SBS Employee Marketplace 3.0.5 on Postgres, and our Test environment is running 3.0.8 on Oracle.
    1. Is there a migration path to transfer the entire database or just the system-wide settings like the branding or configuration data, from Postgres to Oracle?
    2. Would going from 3.0.5 to 3.0.8 affect this?
  2. Once our Test environment is set up, is there a migration path from Oracle to Oracle?  e.g. from Test to Stage?  or Stage to Prod?  Both in terms of:
    1. The entire database?
    2. Or just select data such as system-wide branding or changes made to one environment that we want to propagate to the others without having to re-do it manually?

 

Thanks!

Eric Hendrickson

Tags: oracle, migration, postgres
Karl Cyr Jive Employee
Karl Cyr
6,819 posts since
Mar 12, 2008
Currently Being Moderated
Oct 8, 2009 9:48 AM in response to: erichendrickson
Re: Database Migration methods?

Hi Eric,

 

There are two places where instance-specific data are stored: the database and the jiveHome directory. The database stores all content and settings for the application. The jiveHome directory stores some metadata and custom themes.

 

If you wanted to port an SBS instance from one server to another, and change databases in the process, you would need to do the following:

 

  1. Install a new instance of SBS on the new server.
  2. Copy the entire contents of the jiveHome folder from the old server to the new server.
  3. Run the database migration utility.

 

Detailed information on how to perform the migration can be found here: http://www.jivesoftware.com/builds/docs/jive_sbs_employee/latest/admin/InstallingOnLinux.html#upgrading_an_rpm_installation.

 

Hope that helps!

 

Regards,

Karl

erichendrickson Novice
erichendrickson
33 posts since
Jul 14, 2009
Currently Being Moderated
Oct 8, 2009 11:24 AM in response to: Karl Cyr
Re: Database Migration methods?

Hi Karl,

 

So is it fair to say then, that copying a complete Jive environment is possible this way, even from 3.0.5 on Postgress to 3.0.8 on Oracle, but copying just portions (say, selected system-wide settings or branding/look-and-feel settings) is not possible?

 

It's the entire environment or nothing, in other words?

 

Thanks,

Eric

Karl Cyr Jive Employee
Karl Cyr
6,819 posts since
Mar 12, 2008
Currently Being Moderated
Oct 8, 2009 2:42 PM in response to: erichendrickson
Re: Database Migration methods?

Hi Eric,

 

If you only want to port over the theme, you can copy the contents of jiveHome/themes to the new server.

 

Regards,

Karl

Karl Cyr Jive Employee
Karl Cyr
6,819 posts since
Mar 12, 2008
Currently Being Moderated
Oct 27, 2009 6:13 PM in response to: Karl Cyr
Re: Database Migration methods?

Hi Eric,

 

Do you have any more questions about this, or can this case be closed?

 

Regards,
Karl

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.