Client Support
Showing results for 
Search instead for 
Do you mean 

Restore TRIM Prod Database to Testing Environment

SOLVED
Go to Solution
Frequent Advisor

Restore TRIM Prod Database to Testing Environment

Hi,

 

There is a requirement to restore TRIM Production Database Backup to a TRIM Testing Server.

 

We would like to know what parameters have to changed after the change ?

Like: Dataset name / Datastore Location .... etc ?

 

Thanks

8 REPLIES
HPE Expert

Re: Restore TRIM Prod Database to Testing Environment

No real requirements, you will just need to take a backup of the prod DB and restore it to your test environment.

 

in terms of the document store, in most cases you don't need a copy of that. Just the DB will be fine. If you want a 1 to 1 replica of prod you can copy the whole store over.

 

Other than that there shouldn't be any other changes required.

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Hewlett Packard Enterprise**
HPE Expert

Re: Restore TRIM Prod Database to Testing Environment

[ Edited ]

An oldie but a goodie:

 

 (see attachment)


Neil

Note: Any posts I make on this forum are my own personal opinion and (unless explicitly stated) do not constitute a formal commitment on behalf of HPE.

(Please state the version of CM you're using in all posts. At any given time, HPE are supporting approx. 30+ released versions)

HPE Software Support Online (SSO): https://softwaresupport.hpe.com/
Valued Contributor

Re: Restore TRIM Prod Database to Testing Environment

I rarely/never see anybody mention the "migrate" function when creating a new dataset in TES.  Is there a reason for that?

Honored Contributor

Re: Restore TRIM Prod Database to Testing Environment

I used it all the time.  Back in the day it wasn't all that handy.  But now it's the most efficient way to move between databases.  Though it does take longer than a simple backup/restore.

Valued Contributor

Re: Restore TRIM Prod Database to Testing Environment

Does it perform additional validation though, compared to copy/pasting a database and editing the DBID?

Honored Contributor

Re: Restore TRIM Prod Database to Testing Environment

Neither approach has any sort of validation.  What validation were you looking for?

Valued Contributor

Re: Restore TRIM Prod Database to Testing Environment

I figured that if the migrate feature rebuilt everything one item at a time if there was a constraint error or other problem it would be flagged?  Otherwise it would only come up during a schema repair or something.

Honored Contributor

Re: Restore TRIM Prod Database to Testing Environment

It's really just moving the data.  As you mentioned, you'd use the Schema Repair feature to validate constraints, indexes, views, SP's, etc.

//Add this to "OnDomLoad" event