Hi!

> I am SLOWLY moving all my databases from Microsoft SQL to Firebird (because
> firebird is SOOO Quick and Free and MORE stable then MSSQL)
>
>
>
> Anyway I have a few questions
>
>
>
> Question 1
>
> In MSSQL I can use nvarchar(max)

If this is some sort of MEMO type, thus, allowing to store a huge number
of characters in a field, then you'd best use

BLOB SUB_TYPE 1

in Firebird.

> What would that be in FireBird? I need to entry to beale to have the MAX
> storage for it as possible (as it can store from 1 line to millions (as this
> is used to handle the Journal entry of a checkin system and the customer
> wants to keep the entrys for 6 years or more)
>
>
>
> I hope someone can help me with this as this is THE ONLY problem I have at
> the moment with Firebird (every other database moved over with no problem)
> Just have to move the data over once I have this table sorted.
>
>
>
>
>
> Question 2
>
> Is there a quick way to import data from a MSSQL database to a FireBird
> Database?

Our product Database Workbench supports both DBMS engines and also
allows you to migrate data and metadata. Check it out:
http://www.upscene.com



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/