Hello
I hope it's the last time I need it. I try the command:
MIGRATE DATABASE FROM "BDE" USING DatabaseName = 'Kb', Transliterate = False
WITH DATA
and I get the error:
ElevateDB Error #700 An error was found in the statement at line 1 and
column 1 (Missing SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP,
GRANT, REVOKE, BACKUP, RESTORE, COMPARE, SET BACKUPS, MIGRATE, REPAIR,
VERIFY, OPTIMIZE, IMPORT, EXPORT, DISCONNECT, REMOVE, PUBLISH, UNPUBLISH,
SAVE, LOAD, SET UPDATES, COPY FILE, RENAME FILE, DELETE FILE)
?
Thanks Sorin

I use EDB Ver. 2.21b1 on Delphi XE5
Sorin

"Sorin H"  wrote in message
news:AFC5F520-1C41-4AB3-8373-B55A547E0EBE@news.elevatesoft.com...

Hello
I hope it's the last time I need it. I try the command:
MIGRATE DATABASE FROM "BDE" USING DatabaseName = 'Kb', Transliterate = False
WITH DATA
and I get the error:
ElevateDB Error #700 An error was found in the statement at line 1 and
column 1 (Missing SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP,
GRANT, REVOKE, BACKUP, RESTORE, COMPARE, SET BACKUPS, MIGRATE, REPAIR,
VERIFY, OPTIMIZE, IMPORT, EXPORT, DISCONNECT, REMOVE, PUBLISH, UNPUBLISH,
SAVE, LOAD, SET UPDATES, COPY FILE, RENAME FILE, DELETE FILE)
?
Thanks Sorin

Sorin,

<< and I get the error:
ElevateDB Error #700 An error was found in the statement at line 1 and
column 1 (Missing SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP,
GRANT, REVOKE, BACKUP, RESTORE, COMPARE, SET BACKUPS, MIGRATE, REPAIR,
VERIFY, OPTIMIZE, IMPORT, EXPORT, DISCONNECT, REMOVE, PUBLISH, UNPUBLISH,
SAVE, LOAD, SET UPDATES, COPY FILE, RENAME FILE, DELETE FILE) >>

Please email me the BDE database that you're trying to migrate (.zip please), and I'll take a look.

Tim Young
Elevate Software
www.elevatesoft.com

Sorin,

<< I use EDB Ver. 2.21b1 on Delphi XE5 >>

Are you sure that you're using the 2.21 BDE migrator ?  I just tried the migration here with the source BDE database that you sent me, and it works fine with the latest version of ElevateDB.

Tim Young
Elevate Software
www.elevatesoft.com

I believe I do. In the properties details is written:
Product version: 2.21
File version 2.21.0.1
Date modified  17/01/2016 13:21

Thanks Sorin

"Tim Young [Elevate Software]"  wrote in message
news:0A0B3754-0211-4A72-B8A9-91B27E4807C6@news.elevatesoft.com...

Sorin,

<< I use EDB Ver. 2.21b1 on Delphi XE5 >>

Are you sure that you're using the 2.21 BDE migrator ?  I just tried the
migration here with the source BDE database that you sent me, and it works
fine with the latest version of ElevateDB.

Tim Young
Elevate Software
www.elevatesoft.com

Sorin,

<< I believe I do. In the properties details is written:
Product version: 2.21
File version 2.21.0.1
Date modified  17/01/2016 13:21 >>

Yes, but is that the migrator module that is registered in EDB ?  You can verify this by using this query:

SELECT * FROM Configuration.Modules

That will tell you which migrator modules are registered, and where they are located.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim

I try your suggestions and also when I open the View installed modules on
the Edb manager the first line is
edbmigratebde.dll FileVersion 2.21 build 1.

I also try the Migrate Database option from the  Manager and here I get the
strange error:
#202 error occurred with the module edbmigrateado (The module could not be
loaded... found)
And I want to use edbmigratebde.

I try to disconnect and create again the session and it doesn't help
Sorin

"Tim Young [Elevate Software]"  wrote in message
news:F2CAD97F-A357-4D0E-AEF9-78E0407C8597@news.elevatesoft.com...

Sorin,

<< I believe I do. In the properties details is written:
Product version: 2.21
File version 2.21.0.1
Date modified  17/01/2016 13:21 >>

Yes, but is that the migrator module that is registered in EDB ?  You can
verify this by using this query:

SELECT * FROM Configuration.Modules

That will tell you which migrator modules are registered, and where they are
located.

Tim Young
Elevate Software
www.elevatesoft.com

Sorin,

<< I also try the Migrate Database option from the  Manager and here I get the strange error: #202 error occurred with the module edbmigrateado (The module could not be loaded... found) >>

This error is because you're using the ADO migrator, not the BDE migrator.  Please review the steps detailed here on how to migrate a database using the EDB Manager:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Migrating_Database

Tim Young
Elevate Software
www.elevatesoft.com