Large objects and SQL Server

[itsbruce]

I'm having to migrate a database from Postgres to SQL Server 2000. The front-end is PHP4/Apache on Linux. One thing that puzzles me is how to insert large objects (e.g. files) into the MSSQL database using PHP.
I've compiled PHP against FreeTDS and unixODBC and so can use either the ODBC or Sybase interfaces to access the database but can't see a function from either set that would help me.

Thanks in advance for pointing out the obvious that I have missed.

[Anon]

I doubt you will get any useful replies to this one - if you do they will be along the lines of why move from Postgres (Linux over Microsoft at all odds cut off nose dispite face geek heaven) to MS-SQL 2000 (grrr Microsoft shame on them for making things useable).....

I would suggest using the MSSQL functions and maybe the binary field in MSSQL? as for the PHP isn't it just a sql insert statement (using the mssql_query functions etc)???

itsbruce wrote:

I'm having to migrate a database from Postgres to SQL Server 2000. The front-end is PHP4/Apache on Linux. One thing that puzzles me is how to insert large objects (e.g. files) into the MSSQL database using PHP.
I've compiled PHP against FreeTDS and unixODBC and so can use either the ODBC or Sybase interfaces to access the database but can't see a function from either set that would help me.

Thanks in advance for pointing out the obvious that I have missed.