Restore SingleDB on 122.08 to Multi Tenant DB on HANA 2.0 SPS01

Just tested recover a single Database to Multi Tenant Database without the need to convert them to MDC beforehand with below scenario and thought it is a good idea to share.

This enhancement only work on target >= HANA 2.0 SPS01 and is particularly useful where it keeps your source/ productive database intact and allows you to to perform a series of testing before converting them to MDC, especially if you plan to upgrade to HANA 2.0 SPS01 since MDC would be the standard and only operation mode.

Enterprise Readiness with SAP HANA

Data Centers as the “Power Plants” of the digital Economy

Data centers are the power plants of today’s businesses. However, planning high availability into a system landscape may often be an overlooked aspect by some businesses. As more elements ranging from devices, people, equipment and other systems become increasingly connected, the costs after an unplanned outage is definitely becoming more significant. In the always-on digital economy, companies that rely on data to make decisions, conduct transactions, and interact with consumers cannot afford data center blackouts.

Make the new standalone HANA 2 Cockpit work for you

After installing my first HANA 2 system, I realized that the HANA Cockpit is no longer an integral part of the database instance as it was with HANA 1, as is clearly stated in the HANA Cockpit Installation and Update Guide:

Upgrade your HANA, express edition to HANA 2

1. Temporarily increase memory to 23.9 GB
2. Create temporary user
3. Uninstall HANA 1
4. Install HANA 2
5. Install AFL

In order to allow for the upgrade to HANA 2, I have to temporarily increase the memory of my virtual machine to 23.9 GB as before:

Transforming Database Management with the new SAP HANA 2 feature, Active/Active read-enabled

Tech Ed Barcelona 2016 is happening now this week from Nov 8 – 10, and an exciting announcement was made for SAP HANA 2. With the launch of the next generation platform SAP HANA 2, SAP is looking further to bring greater stability and agility for customers looking to build a solid foundation for innovation and digitalization.

A key feature announced is Active/Active Read-Enabled. Along with enhanced data encryption, workload management and the SAP HANA Cockpit, these new features look to help further simplify and Free up IT efforts to allow them to focus on innovation.