cancel
Showing results for 
Search instead for 
Did you mean: 

Backup/Restore Tables

nikhil_bose
Active Contributor
0 Kudos

hi experts,

How can I Backup/Restore MaxDB Tables? Actually I want to copy Tables along data from instance to another.

Please give me step by step procedure to achieve the task.

thanks in advance

nikhil

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

If you want to transport a table form one server to another then you can use Database Studio. There you can simply drag/drop the table between two databases.

or check following

/people/kathirvel.balakrishnan2/blog/2005/02/03/import-and-export-data-in-maxdb-using-sqlcli-and-batch-files

regards,

kaushal

nikhil_bose
Active Contributor
0 Kudos

thanks kausal

any other thoughts to copy from one instance to another instance?

Former Member
0 Kudos

Hello,

if you want to build a script based solution you can use the loadercli.

To find out the commands for the MaxDB loader to transport tables between two databases the easiest way is to use Database Studio and check the console window of Database Studio.

Or you can check the documentation of the MaxDB loader http://maxdb.sap.com/doc/7_7/59/025741c0c28447e10000000a1550b0/content.htm .

Best Regards

Wolfgang

Former Member
0 Kudos

Hi,

Run loadercli -u <user name>,<pw> -d <db name>

then use EXPORT Tabel command

check http://maxdb.sap.com/doc/7_7/60/81f449bfd448f38f8c01db84a2b736/content.htm

regards,

kaushal

nikhil_bose
Active Contributor
0 Kudos

hi Wolfgang,

Other than scripts is there any API support available?

Actually I want to develop an WebDynpro which does the backup/restore process.

thanks in advance

nikhil

Former Member
0 Kudos

Hello,

to backup and restore a database you can use the dbmcli http://maxdb.sap.com/doc/7_7/44/dcdbec10916c31e10000000a114a6b/content.htm.

When you want to use the loader to backup some tables you have to keep in mind that the loader is an ETL tool and was not designed for backup purposes.

Things like consistence between tables are not guaranteed and you have to resolve this in your application.

The loadercli and the dbmcli can be used via JDBC using the powertoys extension.

http://maxdb.sap.com/doc/7_7/44/dcdbec10916c31e10000000a114a6b/content.htm

http://maxdb.sap.com/doc/7_7/46/7bc39ee97150d1e10000000a155369/content.htm

Best Regards

Wolfgang

Answers (1)

Answers (1)

nikhil_bose
Active Contributor
0 Kudos

thanks kaushal & wolfgang