[TIP] HOW TO merge info from few dbs using XML dump and XML editor.

[Ruslan Zasukhin]

On 30/5/07 7:03 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

Hi Barry,

> This is how I did it (just the structure for this test):
> 
> Down load and unzip the following Free and simple XML Editor:
> http://www.firstobject.com/dn_editor.htm
> 
> 
> Always, always keep a backup of your files.
> 
> 
> 1) Dump the source to a source. XML file and the destination databases to a
> destination. XML file
>  Valentina Studio | File | Dump Database ... | XML ... | (select appropriate
> Dump data options and Set... File)
> 
> 2) Run two versions of the XML Editor
>     a) Open the source .xml in one
>     b) Open the destination .xml in the other
> 
> 3) in the source .xml Locate and copy the XML Table or Fields you want
> 
> 4) in the destination .xml Locate and Paste into the appropriate place then
> save
> 
> 5) Back in Valentina Studio select the correct Database and Load Dump ...
>     Valentina Studio | File | Load Dump ... | XML ... | (Select the
> destination .xml)
> 
> That should be it!

Very interesting TIP :-)


-------
One warning.

All this merges of tables and fields work until you not use ObjectPtr or
Binarylinks.

For them we plan develop also XML-based procedure of dump and load linked
records from few tables with automatic adjusting of RecID and Ptr values.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]