on 01-20-2010 3:39 AM
Hi,
we have maxdb 7.7 (64 bit) and database studio (A).
I can export a schema - no problem.
Now I wanna import the schema into a 32 bit maxdb 7.7 on a different computer but but this destination has no connection to the database studio (A).
I installed a new database studio (B) on the destination computer und copied all packages from source to destination.
When I wanna import the exported schema, I cannot see all my packages.
Is it not possible to export/import objects between different databases via different DB studios?
Thanx for your help.
regards
Wolfgang H.
Hello,
Database Studio (A) stores the package information in a local user folder.
The new Database Studio (B) does not know about the copied packages.
But you don't have to install a second Database Studio (B) and copy your data.
Just register the second database in Database Studio (A) and do the import.
Best Regards
Wolfgang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
sorry the feature is available from version > = 7.8.
On your own risk you can do some manual work do make the data available in Database Studio.
There is a file transport.log in the directory "C:\Documents and Settings\<user>\Application Data\sdb\loader\log
Open the file on computer (A) insert the line from your schema export to the transport.log on computer (B).
As a orientation you can use the time stamps of the entries.
Maybe you have to change the computer name (A) under SOURCE_NODE to computer (B).
Best Regards
Wolfgang
Hi Wolfgang,
how many tables do you want to copy? Maybe the manual way is better. Use the MaxDB loader.
Here is an example:
1) Connect:
loadercli -d MAXDB -u user,secret
2) Extract table:
DATAEXTRACT FOR DATALOAD TABLE wolfgang OUTSTREAM 'wolfgang.command' OUTSTREAM 'wolfgang.data'
The execution of the command results in two files: the command file (containing the definition of the table) and the data file (containing the entries of the table).
3) Copy the files to the standalone machine
4) Load the tables one by one:
loadercli -d ALONE -u user,secret
loadercli> dataload table wolfgang INSTREAM 'wolfgang.data'
HTH
André
Hello,
if you want to use the loadercli you can find the import commands in a file e.g. <timestamp>.IMPORT which is part of the export package of Database Studio. This file was generated by Database Studio and contains all the commands to import your exported schema data.
Best Regards
Wolfgang
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.