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 |
|
sqldev6
Starting Member
18 Posts |
 Posted - 2008-04-28 : 05:20:07
|
| Hi All,We are extracting the data from ORACLE databse into SQL Server 2005 database. Both are hosted on different servers.For this we have created linked server on SQL Server and we using the OPENQUERY to extract the data. Its taking too much time to extract the data.Is there any other alternate thing for OPENQUERY clause.Please help me on this.Thanks in advance.Thanks,Ramesh. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-04-28 : 05:23:30
|
| export to bcp then import?in any case you should be importing data by batch not one time since a break in connection will roll everything back--------------------keeping it simple... |
 |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-04-28 : 07:36:47
|
| if you can install oracle OLEDB driver, you u can import them using OLEDB data source---------------------http://dineshasanka.spaces.live.com/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-28 : 22:35:33
|
| With ssis package. |
|
|
|
|
|
|
Extracting the Oracle data into SQL Server 2005.