On the list I do not have 1 should I Select TEXT?

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 19 September 2010 11:32 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] What would this be in Firebird?

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/


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links




----------


No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.851 / Virus Database: 271.1.1/3145 - Release Date: 09/19/10 07:34:00


[Non-text portions of this message have been removed]