We are migrating a Oracle database to SQL Server 2008. But are having issues importing a table that has BLOB datatype in Oracle.
Can someone help me on "how to convert or import BLOB data to SQLServer from Oracle"?
Use SQL Server Integration Services (SSIS) to create a SSIS package and import that data. Try using the .NET Framework Data Provider for Oracle on the SSIS package to get connected to the Oracle database.
Hope this helps.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?