Tim,

Now that I have the new 1.07 DB I woudl like to try and migrate a SQL database over, when we last spoke I mentioned it woudl be a great idea to have strings over 256 in
length to be converted to clobs and you agreeed. I was wondering a) where I can get the sql migration dll, I cant remeber for the life me where i can download it from and
where i install it to.

Regards,

David

David,

<< Now that I have the new 1.07 DB I woudl like to try and migrate a SQL
database over, when we last spoke I mentioned it woudl be a great idea to
have strings over 256 in length to be converted to clobs and you agreeed. >>

Actually it is 512 characters, but yes, it is in there:

http://www.elevatesoft.com/scripts/incident.dll?action=viewaddr&category=edb&release=1.07&type=f&incident=2499

These > 512 character columns will be automatically converted to CLOB
columns now.  However, EDB will simply skip any columns greater than 512
characters when creating the indexes since EDB cannot index BLOB or CLOB
columns, apart from text indexes.

<< I was wondering a) where I can get the sql migration dll, I cant remeber
for the life me where i can download it from and where i install it to. >>

See here:

http://www.elevatesoft.com/edb_faqt_4.htm

--
Tim Young
Elevate Software
www.elevatesoft.com