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 |
|
psangeetha
Yak Posting Veteran
95 Posts |
 Posted - 2008-03-21 : 12:17:18
|
| Hi all, I have worked mostly in oracle, and new to sql server. I am trying to move a very small table from oracle database to sql server database. I see a different methods I can do this, I guess DTS etc.I tried import wizard in SSMS, I was not succesful in that.Can any expert suggest me any possible ways of doing this the best way? Thank you very much! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-21 : 12:19:16
|
| Use DTS . |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-21 : 12:25:58
|
| If DTS is not OK , then script the schema , recreate the table in SQL Server , than use the Import Data wizard.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
psangeetha
Yak Posting Veteran
95 Posts |
Posted - 2008-03-21 : 12:46:55
|
| I recreated the table in sql server, and has no records now. I tried importing the records from oracle using excel file, I dont see an option just to insert records. Please help.. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-21 : 12:49:39
|
| Check bulk-insert in BOL. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 20:12:49
|
| To use dts, you need oracle ole db provider on sql server. |
|
|
|
|
|
|
Move table to sql server