I would like to create an SQL copy from a HANA database. What is the best way to do this? Something with Quickcopy or does anyone have any tips? Merci Thomas
If you are looking to export database objects from one SAP HANA database and import them into another SAP HANA database, one option is to use the export and import catalog commands. The tutorial https://developers.sap.com/tutorials/hana-dbx-export-import.html attempts to demonstrate how to use the SAP HANA database explorer to perform export and import operations as well as the associated SQL that can be used.
Hi Dan_vL, thank you for your reply. Unfortunately, that's not what I mean. It is as follows: My customer has a B1 Hana DB on premise. Now, however, a clone of this DB is to be created as MS-SQL 2019 on premise for testing purposes. To avoid having to do a lot of exports and imports, a wizard tool like Quickcopy would be very helpful. Is this perhaps even possible with Quickcopy? Is there a tutorial for this? Or is there another tool for this? Or does it not work at all? The question of all questions: How can I create the same HANA DB as an SQL DB? Best regards Tom
I am not familiar with Quickcopy. Can you post a link to more details on it? I am not aware of option to export a HANA database into a MS-SQL 2019 database. Some third party tools do provide tools to work with multiple databases. DBeaver is one of them. I have not tried this option but am including it here incase it is helpful. https://github.com/dbeaver/dbeaver/wiki/Data-migration/4f0c95c80b3cba986f921bdd49c0346223b1831e
Hi Dan, B1 Quick Copy find you here: Administration\System Initialisation\Implementation Centre\Implementation Tasks\Data Management\Copy Data between Companies\ Tadaaaa: Now the Quick Copy form opens 🙂 but the main question is still: How do I turn a Hana database into a SQL database (not the other way round!)? I would like some guidance, as I unfortunately have no experience with HANA databases. Kind regards, Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.