on 06-20-2008 5:55 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
thanks kaushal & wolfgang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.