Hi,

I cannot seem to get the Migrators to work. When I create a migrator (from the modules of the ADD tools 203) there never seem te be migratorParams. I can't seem to get the migrators recompiled. All kinds of errors, missing declarations.....

I tried making my own Migrator using the Migrator wizard. But when I implement the getparams event the server hangs when I copy my dll to the server dir.

is the Migrator still supported in 203 or is this something of the ancient past and should I go another route?

Kick,

<< I cannot seem to get the Migrators to work. When I create a migrator
(from the modules of the ADD tools 203) there never seem te be
migratorParams. I can't seem to get the migrators recompiled. All kinds of
errors, missing declarations..... >>

What version of Delphi are you trying to create a migrator with ?  If you
want to post your project code, I can tell you what the issue is.

<< is the Migrator still supported in 203 or is this something of the
ancient past and should I go another route? >>

No, the standard migrators use the same code and custom modules, so they
should work fine.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<<What version of Delphi are you trying to create a migrator with ?  If you
want to post your project code, I can tell you what the issue is.>>

I use Delphi 6.
I tried to compile all the migrators in the additional\version 2\Libs\xxxx directories. None of them work. They all say "File not found edbmigrate.dcu".

So I tried creating a custom migrator, which I attached. Didn't work either, server crashes when starting. Seems to be when I add params. When I comment that out it doesn't crash.

Kick,

<< I use Delphi 6. I tried to compile all the migrators in the
additional\version 2\Libs\xxxx directories. None of them work. They all say
"File not found edbmigrate.dcu". >>

It's in the \code\source subdirectory under the main installation directory.
Just copy it to the desired directory that is in your compiler search path,
and then recompile.  I will make a note to include this file in the migrator
source directory also.

<< So I tried creating a custom migrator, which I attached. Didn't work
either, server crashes when starting. Seems to be when I add params. When I
comment that out it doesn't crash. >>

There's an issue with NexusDB being used in the migrator modules with
design-time components.  Don't ask me what the issue is, because I don't
know.  I coded around it with this in our NexusDB migrator:

procedure TNexusDBMigratorModule.EDBMigratorModuleCreate(Sender: TObject);
begin
  FMigrator:=TEDBMigrator.Create;
  FEngines:=TnxseAllEngines.Create(nil);
  FEngine:=TnxServerEngine.Create(nil);
  FSession:=TnxSession.Create(nil);
  FSession.ServerEngine:=FEngine;
  FDatabase:=TnxDatabase.Create(nil);
  FDatabase.Session:=FSession;
end;

procedure TNexusDBMigratorModule.EDBMigratorModuleDestroy(Sender: TObject);
begin
  FreeAndNil(FDatabase);
  FreeAndNil(FSession);
  FreeAndNil(FEngine);
  FreeAndNil(FEngines);
  FreeAndNil(FMigrator);
end;

You can see the reset of the NexusDB migrator source code in the
\libs\edbmigratendb subdirectory.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<<It's in the \code\source subdirectory under the main installation directory.
Just copy it to the desired directory that is in your compiler search path,
and then recompile.  I will make a note to include this file in the migrator
source directory also.>>

Tried that but edbMigrate won't compile. First it's says something about a missing ; at the const declaration. Fixed that, now it's saying that FSourceTable doesn't exist (true, I cannot find a declaration for it). Line 131.

Kick,

<< Tried that but edbMigrate won't compile. First it's says something about
a missing ; at the const declaration. Fixed that, now it's saying that
FSourceTable doesn't exist (true, I cannot find a declaration for it). Line
131.  >>

Be sure to enable this IFDEF in your module project:

{$DEFINE EDB_MIGRATE_NEXUSDB}

that will allow NEXUSDB to work with the existing migrator code.

Did you try just modifying the existing NexusDB migrator source code that we
provide ?  It might be easier since all of this is already handled in it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

This IS with the standard existing migrator code. It simply won't compile.

Kick,

<< This IS with the standard existing migrator code. It simply won't
compile.  >>

You're using the standard existing edbmigratendb.dpr project for the NexusDB
migrator ?

Did you try setting the NexusDB compiler define as indicated ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Sorry I haven't been keeping you informed, but I managed to fix my problem by using the ADO migrator in combination with the ODBC driver for NexusDB. When we roll out the migration to our first customers then it would be better to use a native NexusDB migrator though. So I will be addressing this when that time comes.

BTW: The ADO Migrator crashes when migrating tables with a space in the tablename. Not really an issue for us, but you might want to fix this.

Kick,

<< Sorry I haven't been keeping you informed, but I managed to fix my
problem by using the ADO migrator in combination with the ODBC driver for
NexusDB. When we roll out the migration to our first customers then it would
be better to use a native NexusDB migrator though. So I will be addressing
this when that time comes. >>

No problem.  What is the issue with using the native NexusDB migrator that
we provide (forgetting compilation for a second) - is it the wrong version
(that is, NexusDB 2.x vs. 3.x) ?

<< BTW: The ADO Migrator crashes when migrating tables with a space in the
tablename. Not really an issue for us, but you might want to fix this. >>

I'll check this out, but we enclose all identifiers, including table names,
in double-quotes, so there shouldn't be any issue with spaces.   What is the
error message that you're seeing ?

BTW, I got that Lazarus technical article up finally:

http://www.elevatesoft.com/articles?action=view&category=edb&article=elevatedb_and_lazarus_windows_ce_mobile_build_notes

and I'll be looking into the Winsock issue shortly.

--
Tim Young
Elevate Software
www.elevatesoft.com