Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVE..

  
   Database Help (Home) -> DTS RSS
Next:  database problem  
Author Message
M. Ranft

External


Since: Aug 25, 2008
Posts: 1



(Msg. 1) Posted: Mon Aug 25, 2008 3:47 pm
Post subject: IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVER 2005
Archived from groups: microsoft>public>sqlserver>dts (more info?)
Hallo,

I have a very urgend problem. There is an Oracle database which contains
hundreds of tables and each contain over thousand rows. I need to import
these data from Oracle to MS SQL-Server 2005. All I get is error messages!
(I didn't post them here, because the most important part would be: How do I
get them in the database ... the datatype that should be used,
VARBINARY(MAX) is not available during the "import data"-dialog.

I need urgend help. If anybody can help me, please answer to this.

Thanks in advance

Manuel

 >> Stay informed about: IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVE.. 
Back to top
Login to vote
gina rami

External


Since: Jul 30, 2010
Posts: 1



(Msg. 2) Posted: Fri Jul 30, 2010 6:25 am
Post subject: news? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Manuel, i've your same problem... now, one year after i really hope you've found a solution: can you explain it please?
Thanks




M. Ranft wrote:

IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVER 2005
25-Aug-08

Hallo,

I have a very urgend problem. There is an Oracle database which contains
hundreds of tables and each contain over thousand rows. I need to import
these data from Oracle to MS SQL-Server 2005. All I get is error messages!
(I didn't post them here, because the most important part would be: How do I
get them in the database ... the datatype that should be used,
VARBINARY(MAX) is not available during the "import data"-dialog.

I need urgend help. If anybody can help me, please answer to this.

Thanks in advance

Manuel

Previous Posts In This Thread:

On Monday, August 25, 2008 9:47 AM
M. Ranft wrote:

IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVER 2005
Hallo,

I have a very urgend problem. There is an Oracle database which contains
hundreds of tables and each contain over thousand rows. I need to import
these data from Oracle to MS SQL-Server 2005. All I get is error messages!
(I didn't post them here, because the most important part would be: How do I
get them in the database ... the datatype that should be used,
VARBINARY(MAX) is not available during the "import data"-dialog.

I need urgend help. If anybody can help me, please answer to this.

Thanks in advance

Manuel


Submitted via EggHeadCafe - Software Developer Portal of Choice
Scrolling in WPF Toolkit?s Column Chart
http://www.eggheadcafe.com/tutorials/aspnet/0939d60c-8e17-4a27-b898-1f...2d2d6f6

 >> Stay informed about: IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVE.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Handling BLOB's between SQL Server 2K and mySQL DB !!? - Hi there for some reason I've to modify data in an existing customer database mySql V 4.0.23 . Some data is there stored in BLOB's and I can export the data via DTS into my SQL Server 2K, modify the data and then try to store the data back into mySQL...

importing unstructured data - All I am currently working on a way of importing some excel spreadsheets into MS SQL. Although the spreadsheets are structured visually, they are not very import friendly as there are several tables worth of information below each other on a given..

Importing Query From .sql file? - Hi can u tell me how to fetch query from .sql file while working in DTS 2000? actually, I need to fetch query from . sql file(on local drive) and then want to execute this query on a sql database to export that sql data to a ..txt file using dts..

Lost data importing from Excel - I'm trying to import a small spreadsheet from Excel into a pre-created SQL Server table. One column is defined as char(2), and the data values are actually 2 digits. When the leading digit is non-zero, the data transfers OK, but if the code is, say, '06'...

Error when importing data from Orcale DB to SQL Server DB - Hi, I am trying to importing data to my SQL Server DB using DTS but I am getting errors. I don't have control over Orcale and looks like the errors occur on DataTime fields. Here is the error message: "Error at Destination for Row number 103299, ...
   Database Help (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]