Re: [Squirrel-sql-users] VARCHAR conversion error - Ingres 2006 tables to Microsoft SQL Server 2000 and 2005

[Eric W. <ewh...@bi...>]

Many thanks. I will watch for the snapshot.

Eric Whitchurch

35 Thompson Road UPWEY VIC 3158
Ph: 03 9754 6378 Mobile: 0408 172 789
Email: ewh...@bi...

--------------------------------------------------
From: "Robert Manning" <rob...@gm...>
Sent: Friday, January 25, 2008 12:32 PM
To: "Eric Whitchurch" <ewh...@bi...>
Cc: <squ...@li...>
Subject: Re: [Squirrel-sql-users] VARCHAR conversion error - Ingres 2006 
tables to Microsoft SQL Server 2000 and 2005

> On Jan 24, 2008 8:09 PM, Eric Whitchurch <ewh...@bi...> wrote:
>> > My resolution would be to use the length of the source column as the
>> > length of the destination column and switchover to TEXT type beyond
>> > 8000.  Sound reasonable?
>>
>> Yes that would be reasonable and solves the other problem of varchars
>> greater than 8000.
>
> Ok, that will go out in this weekend's snapshot. It will also be in
> 2.6.5 - which is probably
> a few weeks away.  There is essentially no difference between 2.6.5
> and the snapshot
> with regard to copying tables, since that hasn't really been the focus
> of 2.7 development so far.
> The snapshot will have experimental support for new refactorings which
> are supported
> in SQLServer, but not Ingres as of yet.(It will eventually when it is 
> released).
>
> Rob
>