Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-03-28 : 09:46:41
|
| hello ppls...i am transfering all data and objects of one database from oracle9i to sql server 2000..both running on same server...can any body guide me in this...T.I.APapillon |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-03-28 : 10:48:44
|
| hi..i went through the above link provided by madhivanan but there is no information how to transfer all data from oracle to sql server ..i want one database physically move from....T.I.APapillon |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-03-28 : 11:45:18
|
| I'm having trouble querying from my SQL server 2000 db on my local machine to remote Oracle server 9i. both on same machineI can get the server link setup with both MS OLE DB and the Oracle OLE DB drivers EXEC sp_addlinkedserver @server = 'DBTest', @srvproduct = 'Microsoft OLE DB Provider for Oracle', @provider = 'MSDAORA', @datasrc = 'local_machine_name',GOEXEC sp_addlinkedsrvlogin @rmtsrvname = 'DBTest', @useself = 'false', @rmtuser = 'test', @rmtpassword = 'test'GOEXEC sp_tables_ex DBTestGOi got this errorServer: Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 20OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider returned message: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor]OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].please help me outT.I.APapillon |
|
|
|
|
|
|
transfer one db from oracle9i to sql server2000??