After having a very long break from using ElevateDB, I'm back working with it again and want to convert an ANSI database I created to a Unicode database.  

Is the correct procedure to reverse engineer it, search and replace ANSI with UNI in the script, and then run the generated script in the Unicode database?

Thanks,

-Steve

I have tried doing this but I get some errors.  It is trying to create some stored procedures that reference some tables, but the tables are not created until further on in the script, so it is producing errors.  

I would have thought that the reverse engineering script would create all tables first and then create the stored procedures.

- Steve

<<Steve Gill wrote:

After having a very long break from using ElevateDB, I'm back working with it again and want to convert an ANSI database I created to a Unicode database.  

Is the correct procedure to reverse engineer it, search and replace ANSI with UNI in the script, and then run the generated script in the Unicode database?

>>

While I haven't used it myself the 2.16 has an EDB migrator that should be able to do most of the work for you. Check our release notes and give it a try

Raul

Hi Raul

<< While I haven't used it myself the 2.16 has an EDB migrator that should be able to do most of the work for you. Check our release notes and give it a try  >>

Thanks, I missed that.  I must be stupid because I have now read the release notes but can't work out where I'm supposed to find the migrator.

It says in the release notes: "....is installed automatically via the Create Database Migrators option for each session node.".

Yup, makes absolutely no sense to me.

I can see the edbmigrate.dll in a sub-directory, but I have been right through ElevateDB Manager and can't find a Create Database Migrators option anywhere.

If I select the database and click Migrate Database, the Migrator combo box is empty.

I tried creating the migrator as follows:

CREATE MIGRATOR "ANSI2UNICODE"
MODULE "edbmigrate"
DESCRIPTION 'ANSI to Unicode'

I get an error: "ElevateDB Error #401 The module edbmigrate does not exist in the configuration DBConfig".

So I'm assuming I have to add it to the configuration somehow, although I don't have a clue how that is done.

Thanks.

Steve

Ok, I've worked how to register the migration module and create it.  Got it working now.

Steve,

<< I can see the edbmigrate.dll in a sub-directory, but I have been right
through ElevateDB Manager and can't find a Create Database Migrators option
anywhere. >>

For others that may be lurking: just click on the session node that you're
using in the EDB Manager's treeview on the left-hand side.  It's the node
above the Databases node.  The Create Database Migrators option then appears
as a task link/menu option.

Tim Young
Elevate Software
www.elevatesoft.com