LoadDump making too many files

[Chuck Neal]

Things are getting more complicated...

First, any dump comes in as 4 files, no matter what the dump file says.

I also have an existing project database that I need to use (so names 
can't change).  It uses some table names that Valentina is fine with but 
does not like in a load dump.  (It created the dump fine but will not 
read it back in.) It loaded the dump but skipped a number of tables.

So far the ones I see that are a problem in this file...
Class
Language_Phrase
Option
Parameter
Technique
Technique_Group
Technique_Option

Nothing looks incorrect in the syntax and these are scattered throughout 
the other items that did export.

Is LoadDump just not working (especially in the tool?)

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
--------------------------
Check out the Developers Mall
Your one stop shop for all your Director Xtra Needs
http://www.mediamacros.net/customer


Ruslan Zasukhin wrote:
> On 11/19/05 12:16 AM, "Chuck Neal" <chuck at mediamacros.com> wrote:
> 
> Hi Chuck,
> 
> So you make SQL dump, then do SQL load. And getwrong number of files?
> 
> Ivan, sounds like a bug.
> 
> 
> 
>>I am using Valentina 2 for Director.  When I do a load dump it is
>>creating 4 files instead of everything in one. The DB the dump was made
>>from was a single file and the first part seems to correctly set the
>>type to kDscDatBlbInd
>>
>>This is the start of my SQL dump...
>>
>>SET PROPERTY
>>     DatabaseMode,
>>     DatabaseSegment,
>>     SchemaVersion,
>>     DateFormat,
>>     DateSeparator,
>>     TimeSeparator,
>>     LocaleName,
>>     StorageEncoding,
>>     CollationFrenchCollation,
>>     CollationAlternateHandling,
>>     CollationCaseFirst,
>>     CollationCaseLevel,
>>     CollationNormalizationMode,
>>     CollationStrength,
>>     CollationHiraganaQuaternaryMode,
>>     CollationNumericCollation
>>of DATABASE  TO
>>     'kDscDatBlbInd',
>>     32768,
>>     1,
>>     'kMDY',
>>     '/',
>>     ':',
>>     'en_US',
>>     'UTF-16',
>>     'kOff',
>>     'kNonIgnorable',
>>     'kOff',
>>     'kOff',
>>     'kOff',
>>     'kTertiary',
>>     'kOff',
>>     'kOff';
> 
>