Sadikhov IT Certification forums: Sql Server 2000 And Oracle 9i - Sadikhov IT Certification forums

Jump to content


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Sql Server 2000 And Oracle 9i How can they talk   Bookmark and Share

#1 User is offline   rezamohasin 

  • Member
  • PipPip
  • Group: Members
  • Posts: 98
  • Joined: 15-June 04

Posted 12 September 2004 - 11:56 AM

Hi,
How can export /import data between SQL Server and Otacle 9i? I have bpth the DB in my PC. Please refer me to any website or document.

Thanks
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Other Replies To This Topic

#2 User is offline   vikas 

  • Member
  • PipPip
  • Group: Members
  • Posts: 54
  • Joined: 19-August 04

Posted 12 September 2004 - 03:27 PM

You can use import export utilities of sql server 2000 to import the data from Oracle 9i
0

#3 User is offline   guanerrr 

  • Super Member
  • PipPipPipPip
  • Group: Members
  • Posts: 680
  • Joined: 09-August 04

Posted 13 September 2004 - 04:10 PM

oracle 9i is much better....
0

#4 User is offline   vikas 

  • Member
  • PipPip
  • Group: Members
  • Posts: 54
  • Joined: 19-August 04

Posted 13 September 2004 - 11:42 PM

guanerrr, on Sep 13 2004, 10:10 AM, said:

oracle 9i is much better....

Is there any tool or utility provided by Oracle ?
0

#5 User is offline   paiste2002 

  • V.I.P. Member
  • PipPipPipPipPip
  • Group: Veterans
  • Posts: 1097
  • Joined: 22-March 04

Posted 16 September 2004 - 02:23 AM

You may be able to find something written in perl for this task
0

#6 Guest_fhwi666_*

  • Group: Guests

Post icon  Posted 16 September 2004 - 04:27 PM

hi,

isn't there anything in the database tools from oracle?

http://oracle.ittool...7&h1=381&h2=377

http://www.sswug.org...ort%20%20export

http://searchdatabas...94863%2C00.html

greetings,
fhwi
0

#7 User is offline   twin1943 

  • Member
  • PipPip
  • Group: Members
  • Posts: 93
  • Joined: 28-July 04

Posted 12 October 2004 - 06:02 PM

let's look microsoft what they say:Is SQL Server Better for Your Organization?
See how SQL Server differs from Oracle.

http://www.microsoft...pare/oracle.asp
0

#8 Guest_msanchezo_*

  • Group: Guests

Posted 09 November 2004 - 04:09 AM

i think , the best than you can export information is with text file export
form sql server and import in oracle databses ,because many times
are error with the utilitys like the data export of sql server


is best use tool like the database administrator the oracle enterprise,
tahn let you import information forn sql server or acces database,


but i reccomend ,export text file an import text file into oracle because is more
stable.
0

#9 Guest_denyan_*

  • Group: Guests

Posted 09 November 2004 - 11:27 PM

rezamohasin, on Sep 12 2004, 05:56 AM, said:

Hi,
How can export /import data between SQL Server and Otacle 9i? I have bpth the DB in my PC. Please refer me to any website or document.

Thanks

You can use Linked Server
0

#10 User is offline   nrg_fly 

  • Member
  • PipPip
  • Group: Members
  • Posts: 146
  • Joined: 12-August 04

Post icon  Posted 10 November 2004 - 09:21 PM

rezamohasin, on Sep 12 2004, 05:56 AM, said:

Hi,
How can export /import data between SQL Server and Otacle 9i? I have bpth the DB in my PC. Please refer me to any website or document.

Thanks

Use the DTS of SQL Server.

I’m sure it’s gonna help you.
0

#11 User is offline   explorer 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 256
  • Joined: 18-November 04

Posted 24 November 2004 - 08:49 AM

yes i agree ,DTS is much more easier and simpler to use than anything else.
but u can also use the Oracle 9i import exports but thats messy biz.
0

#12 User is offline   lothdeam 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 3
  • Joined: 27-May 04

Posted 25 November 2004 - 12:55 AM

DTS is the best easy way.
You can also use linked servers to make queries against the Oracle and populate SQL with the results.
0

#13 User is offline   George 

  • Member
  • PipPip
  • Group: Members
  • Posts: 111
  • Joined: 03-May 04

Posted 28 November 2004 - 11:12 AM

You can go to microsoft's site...then to technet....you will find anything you ask...forum installing sql to migrating and transfering file between databases...
0

#14 User is offline   beta611 

  • Super Member
  • PipPipPipPip
  • Group: Veterans
  • Posts: 802
  • Joined: 25-February 04

Posted 29 November 2004 - 01:10 PM

are the databases the same in both platform? you can use erwin to copy the DDL then export the data and there are a few after market tools you can use or you can use the tools in SQL2000 to export
0

#15 User is offline   dbaman 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 3
  • Joined: 07-March 05

Posted 07 March 2005 - 04:09 PM

FastReader from wisdomforce ( http://www.wisdomforce.com ) can be a right tool for you to migrate data between Oracle and SQL Server.

FastReader is a high-speed unload data from Oracle tables into flat text files and creates control files and script for load into SQL Server using bcp. FastReader supports all data types including binary, blob, clob.

Check this out

rezamohasin, on Sep 12 2004, 05:56 AM, said:

Hi,
How can export /import data between SQL Server and Otacle 9i?  I have bpth the DB in my PC.  Please refer me to any website or document.

Thanks

0
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users