Hi all.

I'm now working with Delphi 2007 and ElevateDB 2.9 Ansi but I have purchased Delphi Berlin 10.1 and that version does not seem to allow Ansi.

Can you tell me the easiest way to migrate all databases from 2.9 ansi to 2.24 Unicode?

Thank's and regards.

On 2/11/2017 6:28 AM, Francisco Fernandez wrote:
> I'm now working with Delphi 2007 and ElevateDB 2.9 Ansi but I have purchased Delphi Berlin 10.1 and that version does not seem to allow Ansi.

Can you clarify what you mean when you say it does not allow ansi exactly ?

Both delphi and EDB do support ansi still.

Elevate DB as of 2.15 supports both ansi and uncode (before there were
separate version). You can specify whether to use ansi or unicode at the
engine level using the CharacterSet property
(http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphi&version=XE&comp=TEDBEngine&prop=CharacterSet)
or session level using session CharacterSet property
(http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphi&version=XE&comp=TEDBSession&prop=CharacterSet).

In unicode enabled editions (2009 or newer) this will default to unicode
while for d2007 it defaults to ansi so you do want to control this if
you're sharing code between editions.

I would suggest you review EDB release notes as there have been number
of changes since EDB  2.9 including number of breaking changes.


> Can you tell me the easiest way to migrate all databases from 2.9 ansi to 2.24 Unicode?

You can use ansi still but If you do want to go to unicode then there is
a migrator now.

Again please see release notes but this one is under 2.16 : "A new
ElevateDB migrator is now included with the ElevateDB Manager, and is
installed automatically via the Create Database Migrators option for
each session node. The ElevateDB migrator is useful for migrating
databases between the ANSI and Unicode character sets, or for migrating
databases from one signature or encryption password to another."

as well as manual

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


Raul

Raul.

upppps.... you are right, I thought the new versions did not allow Ansi.

Thank's and regards.