For compatability-reasons with Geomedia I need to write an additional field of the type "varbinary(max)" to all the tables in our SQL Server Spatial database. In FME I can set the varbinary datatype, but I can't set the "max" value. I've asked around and so far it seems the only workaround is to create the field with the datatype "image" and then alter the datatype directly in SQL Server afterwards. Any ideas on how to do a better workaround?
Page 1 / 1
Shooting in the dark here:
Can you use the SQLExecutor directly in FME to create this? For instance run a Query similar to this to create or alter the table (from http://stackoverflow.com/questions/12082961/sql-server-2008-r2-varbinary-max-size) :
CREATE TABLE dbo.blob(col VARBINARY(MAX)); INSERT dbo.blob(col) SELECT NULL; UPDATE dbo.blob SET col = (SELECT BulkColumn FROM OPENROWSET( BULK 'C:\Folder\File.docx', SINGLE_BLOB) alias ); SELECT DATALENGTH(col) FROM dbo.blob;