New options for Resetting DMBS to SQL Server2000

[RobVen]

Hello,

it would be specifically interesting, having more options for resetting DBMS to SQL Server 2000:

It would be nice to have an option for a maximum size of a column of data type varchar. Columns with a size greater than that should be converted to data type text.

Background:
Having an Oracle Database and wanting to convert it to SQL Server 2000.
Say, you have 10 columns of data type varchar2(2000) and 3 columns of data type varchar2(255) in a table.

Converting this table to SQL Server 2000 can result in problems using insert- or update-statements for the resulting table, because the maximum size of a record (8000 bytes) can be exceeded by one statement.

This is because SQL Server supports a maximum size of an inserted/updated record of 8000.
And if you insert into the mentioned table a record with values of the maximum size of the columns, the resulting record size would be greater than 8000 ((10x2000 + 3x255) = 20765 bytes).

So it would be better, for example, converting all varchar2 columns with a size greater than 255 to Sql Server data type text, because the size of columns of this data type is only 16 bytes.
So the resulting size of the record could be less than 8000 ((10x16 + 3x255) = 925 bytes).

I dont know whether this is to specifically to implement.
But I think, further parametrizing "Resetting DBMS" could be an interesting thing.

Regards,
Robert