Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
Migrate problem |
Tue, Feb 2 2016 12:45 PM | Permanent Link |
Hershcu Sorin | 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 |
Tue, Feb 2 2016 12:51 PM | Permanent Link |
Hershcu 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 |
Wed, Feb 3 2016 2:28 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Feb 4 2016 11:26 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Feb 4 2016 12:22 PM | Permanent Link |
Hershcu 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 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 |
Fri, Feb 5 2016 12:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Sat, Feb 6 2016 3:33 AM | Permanent Link |
Hershcu Sorin | 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 |
Mon, Feb 8 2016 6:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |