|
|
 |
| SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server 2000 section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
October 31st, 2007, 08:32 AM
|
|
Authorized User
|
|
Join Date: Dec 2005
Location: Lucknow, UP, India.
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Problem in Import/Export
Hi All,
I am facing problem when I imports data from sql server 2000 to oracle 9i with the help of import/export wizard of sql server
since we are having an Image data type in sql table and blob data type oracle table.
Anybody have solution??
Surendra Parashar
Gurgaon, Hariyana
__________________
Surendra Parashar
Gurgaon,
http://www.geocities.com/surendraparashar
|
October 31st, 2007, 11:20 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Location: , , .
Posts: 559
Thanks: 6
Thanked 1 Time in 1 Post
|
|
What's the problem? Are you getting any errors? Please post the errors and exactly what the problem is.
|
November 1st, 2007, 04:08 AM
|
|
Authorized User
|
|
Join Date: Dec 2005
Location: Lucknow, UP, India.
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi,
Actually, I wanna Import data from sql server table to oracle table by using Import/export wizard.
I am facing unspecified error message.
becoz, In my sql table i have a column data type Image and in oracle table I have Blob data type against Image data type.
Surendra Parashar
Gurgaon, Hariyana
|
November 1st, 2007, 06:27 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Location: , , .
Posts: 559
Thanks: 6
Thanked 1 Time in 1 Post
|
|
Sounds like you need to find out exactly what the data type is and match that data type. It seems that there could be some type of data type mismatch. As you know this is a Microsoft SQL forum so its looking like the people reading here don't really know the answer but logically it seems that the problem could be as I stated. Sorry I can't be of more help to you. Research the data type attributes for Oracle and SQL server.
The best advice I have is 'don't store images in the databases'. Too many headaches.
|
November 6th, 2007, 07:42 AM
|
|
Authorized User
|
|
Join Date: Dec 2005
Location: Lucknow, UP, India.
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Okay Sir,
Surendra Parashar
Gurgaon, Hariyana
http://www.geocities.com/surendraparashar |
November 6th, 2007, 01:16 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Location: , , .
Posts: 559
Thanks: 6
Thanked 1 Time in 1 Post
|
|
Did you find any information on the data types, cross platform?
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
