OLE OBJECT from MSSQL to ORACLE, or save as image
Posted on 2012-04-10
In MS SQL there is a table with image in it.
1. I need to save that image to disk and write image name instead to the database (ORACLE)
2. I need to save that image into ORACLE database.
We have a new program wich works with ORACLE only. But the datasource as you have understood is MS SQL.
Need least painfull migration to ORACLE.
But, since the other department where I get data will continue using the MS SQL, this process should somehow easier as possible.
No problem if to use access.