Subject Re: MS SQL 2 InterBase Wizard
Author Andreas Tille
On Tue, 29 Aug 2000 marcelo.lopezruiz@... wrote:

> Considering this, I've just posted the first version of an sql2gdb
> wizard. I'm hoping this wizard will grow to manage all ADO-based data
> sources, so I won't continue development with the Access-specific
> version (although the wizard does consider Access-specific features,
> such Jet Checks on columns).
>
> As usual, all feedback is welcome.
I finally found it on egroups-pages. I have to admit that I
doesn't like the egroups structure with all this boring
login-cookies-advertising stuff. Couldn't we switch to sourceforge
as other free projects do?

To the sql2gdb wizard:
Looks PROMISING!
There is a (possibly minor) problem in conversion of text-fields.
I have two fields declared text in the database I want to migrate.
The MS SQL to InterBase Wizard says:

Unsupported data type LongVarChar(201) in column <foo> of table <bar>.

I really wouldn't mind if this would be translated into blob which seems
me apropriate for longer texts in Interbase.

Unfortuntely I don't have a copy of your development tools and so
I'm unable to fix the problem myself. Would it be a problem for
you to fix this and upload this version to enable me to complete
the test of your nice conversion utility?
I would have tried to change the type of the field in the MS SQL source
but unfortunately it is running a replication server which prevents
me from changing the tables easily.

Kind regards

Andreas.