Moving tables from Test to Live environment

I have a technical question about Services/Categories.  We are inputting our Service Catalogue into our Test environment and would like to know if this data is stored in one table or multiple and if it is possible to move the table(s) on the back end to our Live environment when done instead of having to input the data twice. 

Thanks,
Lorraine

Tags services service-catalog sandbox Tier-2
Asked by Lorraine Helson on Fri 10/16/15 2:05 PM Last edited Fri 10/16/15 2:16 PM
Sign In to leave feedback or contribute an answer

Answers (2)

This answer has been marked as the accepted answer
Jamey Stock Fri 10/16/15 2:45 PM Last edited Fri 10/16/15 2:45 PM

Hi Lorraine,

Service and Category data is stored separately, although there are only two places where this data is stored. The only way for this to occur would be to write a cutover script that essentially copies over all of the Service Catalog data from the test environment to the production environment.

In short, there is currently no way to automate this process. A technician at your organization would have to create a script that manually transfers this data over from one database environment to the other, as you are installed.

Otherwise, you would need to manually re-create the Service Catalog in the production environment. I hope this helps to explain how service catalog data can be transferred from a sandbox to production. Please let us know if you would like further clarification or there is anything else we can do to help you.

Sincerely,
Jamey Stock
TeamDynamix

1 of 1 users found this helpful.
Lorraine Helson Thu 10/22/15 2:34 PM

Are you able to provide me with the table names for our administrator?

Thanks,

Lorraine

No feedback