cancel
Showing results for 
Search instead for 
Did you mean: 

export/import with DB Studio doesn't work

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Wolfgang,

Thanx for your answer.

my Problem is that I don't have a physikal connection - it is a standalone PC (firewall problems and different network segments)

regards

Wolfgang

Former Member
0 Kudos

Hello,

copy the data to the directory "C:\Documents and Settings\<user>\sdb\loader\packages\export\<server>\>database>"

Choose the menu "Recover Transport History" on the folder packages.

After this the export can be used as an import for the Database Studio (B).

Regards

Wolfgang

Former Member
0 Kudos

Hi,

super - but I cannot find the menu "Recover Transport History" on the folder packages????

sorry

regards

Wolfgang

Former Member
0 Kudos

Hello,

Please check Window->Preferences->Database Studio->"Show My Repository tree in explorer view".

Then you should see a folder Packages in the upper left of the explorer view.

Best Regards

Wolfgang

Former Member
0 Kudos

Hi,

no success - we can't see a folder packages, only

My repository

  • My Objects

  • Shared Objects

  • Folder Local User Folder

regards

Wolfgang

Former Member
0 Kudos

Hello,

what version of Database Studio do you use?

Best Regards

Wolfgang

Former Member
0 Kudos

Hi,

it's 7.7.06.09

Regards

Wolfgang

Former Member
0 Kudos

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

Former Member
0 Kudos

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é

Former Member
0 Kudos

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

Answers (0)