Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 8 of 8 total |
Collation ENU_CI is not valid... |
Thu, May 20 2010 8:17 PM | Permanent Link |
curt McGonkulator, Inc. | Hey, Tim -
I'm trying to migrate a Nexus 2 database to ElevateDB, using the ElevateDB manager, and it routinely fails. Here's the generated SQL: MIGRATE DATABASE FROM "NexusDB" USING "BlankNullStrings" = FALSE, "Collation" = 'ENU_CI', "DatabasePath" = 'W:\Bmt\BmtServer\DB', "TablePasswords" = '' WITH DATA And here's the error message: ElevateDB Error #202 An error occurred with the module edbmigratendb (The collation ENU_CI is not valid) I've tried all kinds of case variants on the collation name. Any insights? Thanks, Curt |
Fri, May 21 2010 3:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Curt,
<< And here's the error message: ElevateDB Error #202 An error occurred with the module edbmigratendb (The collation ENU_CI is not valid) >> You can only use base collation names with the migrators - the case sensitivity, etc. modifiers are gathered from the source database definition. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, May 21 2010 7:25 PM | Permanent Link |
curt McGonkulator, Inc. | Curt,
<< And here's the error message: ElevateDB Error #202 An error occurred with the module edbmigratendb (The collation ENU_CI is not valid) >> You can only use base collation names with the migrators - the case sensitivity, etc. modifiers are gathered from the source database definition. You flew right over my head there, Tim (as you know, I'm new to ElevateDB). So how do I make case insensitive collation the default for a database? Do I have to redefine the collation for each individual column? |
Tue, May 25 2010 5:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Curt,
<< You flew right over my head there, Tim (as you know, I'm new to ElevateDB). >> The collation modifiers (case-sensitivity, etc.) are gleaned from the source database in terms of how the source indexes are defined, specifically: If any column is present in a primary or unique key constraint in the source table, and the primary or unique key index marked as case-insensitive, then the migrator will also mark the column as case-insensitive. If you want to send me the source table CREATE TABLE DDL for NexusDB, I can test it here and see if there are some improvements to be made. There is certainly the possibility that something was missed in this respect. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, May 26 2010 6:43 PM | Permanent Link |
curt McGonkulator, Inc. | Tim -
I was asking--independent of migrator issues--whether it's possible to establish a database-wide (or table-wide) case-insensitive collation for all string-ish columns, or whether it must be defined on a column-by-column basis... Thanks, Curt |
Thu, May 27 2010 8:20 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Curt,
<< I was asking--independent of migrator issues--whether it's possible to establish a database-wide (or table-wide) case-insensitive collation for all string-ish columns, or whether it must be defined on a column-by-column basis... >> Oh, sorry - no, it's column-by-column only. -- Tim Young Elevate Software www.elevatesoft.com |
Sun, May 30 2010 7:04 PM | Permanent Link |
curt McGonkulator, Inc. | Any chance in the future of supporting a "default collation" for a database, like the big guys do?
|
Tue, Jun 1 2010 3:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Curt,
<< Any chance in the future of supporting a "default collation" for a database, like the big guys do? >> Sure, I can add it as a enhancement request. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |