I have just done something very similar, but it was some manual work. I exported
the metadata from the database, and wrote a quick script to go through and
change any NULLable varchar fields to NOT NULL DEFAULT ''. From there, it is a
matter of going through your current database and simply updating the NULL
fields to ''.

IB DataPump may should be able to convert your NULLs for you as well as moving
the data.

Jason

Fabrício Fadel Kammer wrote:

> OK,
>
> Are there a solution to I create a new database using the metadata of my
> actual database setting the NOT NULL and defining the default = ''
> (empty strings) ???
> And how can I migrate the data from my old database (where I can have
> null strings) to my new database (where I couldn't have null string)
> setting the null string fields to empty strings ''?
>
> Thanks again
>
> Fabrício
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.