Skip to Content

Move Data from a Trial to a Production Instance

test
0 %
Move Data from a Trial to a Production Instance
Details

Move Data from a Trial to a Production Instance

Learn to move data, HDI containers, schemas and more from your trial instance to your production instance of SAP HANA Cloud, SAP HANA database.

You will learn

  • To move development objects from a trial environment of SAP Business Application Studio
  • To export catalog objects like schemas and tables from a trial environment of SAP HANA Cloud, SAP HANA database
QR code

Prerequisites

  • You have access to a trial account and a production account in SAP HANA Cloud.
  • You have access to a trial and production environment in SAP Business Application Studio.

If you have data or any kinds of artifacts in your trial account and you would like to make sure you can keep these artifacts in a production environment, then this tutorial will help you. Please remember to follow these steps before your trial account expires, otherwise it won’t be possible to recover this data.

For moving objects between trial and production, it’s important to differentiate between catalog objects, like tables and schemas, and development objects you created in development projects using SAP Business Application Studio.

In the first three steps of this article, you will learn how to move development objects, steps four and five will focus on catalog objects.


Step 1: Export artifacts from trial account

The recommended way to move your artifacts within HDI containers is to deploy each of them to your production environment. To do that, you need to use the SAP Business Application Studio.

  1. In SAP Business Application Studio, go to your workspace.

  2. Right-click on your project name and the click on Download. Your export package will be prepared and downloaded for you.

Log on to answer question
Step 2: Import artifacts into production account
  1. On your productive SAP Business Application Studio, right-click on the Project folder that you want to import your project to.

  2. Click on Import Project.

  3. Select the file you have downloaded before.

  4. Your project will be imported, and you will see a confirmation on the bottom right-hand side of the screen.

  5. To upload individual files, right-click on the project folder and select Upload files.

You can find more information on importing projects to SAP Business Application Studio here.

Alternatively, you can connect to a local or remote Git repository and transfer your projects to that repository. In your production environment, you can then create a new project directly from a git repository clone.

Learn all about using Git with SAP Business Application Studio here.

Log on to answer question
Step 3: Deploy development objects to production instance

Finally, if you don’t need your design-time project and would rather deploy your development objects to a production instance, please follow these steps:

  1. In the SAP HANA Projects panel, use the deploy icon (Deploy) to deploy the imported project.

  2. Once the deployment is successful, find the mta.yaml file in your project folder and right-click on it.

  3. Select Build MTA Project.

    build MTA project
  4. This will create a folder called mta_archives. Expand this folder.

  5. Right-click the .mtar file within this folder and deploy it.

  6. Select Deploy to SAP BTP.

  7. Select the API Endpoint, Organization and Space of your production environment.

  8. Click on Deploy.

For more information on Developing Multi-Target Applications, please see this article.

If you prefer to work with the Command Line Interface (CLI), just follow this tutorial.
If you wish to develop applications with the SAP Business Application Studio, please see the following technical documents:

For more details on SAP HDI Containers, please see the technical documents of the following topics:

Log on to answer question
Step 4: Export catalog objects

In case you would prefer to export your catalog objects, you can see below the options available.

IMPORTANT: Since the user you use to import object with is the owner of those objects, make sure you are not importing any objects using the DBADMIN user. This is a security best practice. Instead, to import development objects, you can use any developer user that is allowed to develop in the intended space.

If you simply wish to export a mixed list of artifacts in your main SAP HANA Cloud database, you can export the catalog using the SAP HANA Database Explorer. To get started:

  1. In the SAP HANA Database Explorer, expand the database to see the Catalog.

  2. Right-click on Catalog.

  3. Click on Export Catalog Objects.

  4. Add the name to your export file on the Local archive field.

  5. Click on Add Catalog Objects to add objects to your export file.

  6. Use the search to find the objects you wish to include on your export. Click on each object and then click on Add to export.

  7. You can select a binary format instead of a CSV on the Column Table Format field.

  8. Once you are happy with your selection, click on Export.

Log on to answer question
Step 5: Export schemas

If you simply wish to export everything within a particular schema, you can export it with the following steps:

  1. In the SAP HANA Database Explorer, expand the database to see the Catalog.

  2. Right-click on Schema.

  3. Click on Export Catalog Objects. Your schema will be automatically included in the list.

  4. You can select a binary format instead of a CSV on the Column Table Format field.

  5. Once you are happy with your selection, click on Export.

Log on to answer question
Step 6: Export individual tables

If you simply wish to export one individual table, you can export it with the following steps:

  1. In the SAP HANA Database Explorer, expand the database to see the Catalog.

  2. Click on Tables.

  3. On the left-hand panel at the bottom, right-click on the table you wish to export.

  4. Click on Export Catalog Objects. Your table will be automatically included in the list.

  5. You can select a binary format instead of a CSV on the Column Table Format field.

  6. Once you are happy with your selection, click on Export.

You can read more about exporting schemas, tables, and other catalog objects here.

Alternatively, you can also export HDI Containers, if needed. Please see the documentation on the topics given below:

You have completed this tutorial!

Enjoy your production environment and make sure to check out our other tutorials.

Follow our tag in the SAP Community to stay up-to-date on the latest updates and newest content! For more learning materials on SAP HANA Cloud, click here.

Log on to answer question
Step 7: Test yourself
Which of these database objects can be moved from trial to production instance using a csv file?
×

Next Steps

Back to top