>I have not successfully foung much information about
>DesignFileToSQLLoader or fsagsql on Internet
I won't be surprised as there are very limited users of these
Intergraph products
>>If saving a DGN file in a row in the database, I would guess that saving
a
>>single element would be just as easy.
No, it is not. Saving the whole file in one row is much simpler. It is
just like save a picture in SQL Database.
Saving each element in a row is a different story. You will need to
break the file into pieces first. It is not that difficult as the file
format of V7 is open and simple. Then the show stopper comes, if you
want a database field for color, type or level or some other
information of this element, you will have to parse each block of the
bytes. For example, the first two byte of each element tell you the
color, level and type of this element.
>Which data type would I need to use for the MS elements within SQL
>Server? And if saving the whole DGN file; which data type would that
>be?
The maximum size of a dgn file (v7) is 32M. The maximum size of an
element is 64K (Not sure about this). So MSSQL image data type is your
only option.
Are those dgn files V7 or V8? Do you need query them later by color or
level, etc?
|
