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 |
|
saurabh811
Starting Member
33 Posts |
 Posted - 2009-02-10 : 18:14:06
|
| Hi,i have table A in sql server 2005 database and i have table B in oracle9i.i want to insert some records from table A to table B(sql server to oracle)which are possible ways???i know you can select data using openquery from oracle into sql server vai linked server.but how to insert data from sql server to oracle.???i read about insert openquery...how exactly that works???pls help me here...thanks |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2009-02-10 : 18:55:32
|
| You may have to setup a linked server from SQL Server to Oracle. Check out this:http://support.microsoft.com/kb/280106Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-10 : 20:37:35
|
| You can use Export/Import Wizard as well. |
|
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2009-02-11 : 12:34:02
|
| Thanks for reply.i know how to setup linked server.i do have linkedserver from sql server to oracle.but if know that can you explain how exactly insert openquery work?? if possible then pls give me example,,,insert data from sql server to oracle...i mean i have to select only two column from sql server table and want to insert only those column into oracle....thanks, |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-11 : 13:51:56
|
| http://msdn.microsoft.com/en-us/library/ms188427.aspx |
|
|
|
|
|
|
insert data from sql server to oracle