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 |
|
Asteroid
Starting Member
13 Posts |
 Posted - 2009-01-28 : 04:27:21
|
| Hi Guys,we need to import data from oracle server to SQL server on daily basis.let me clarify the problem, we have Oracle database on a LIVE system which is being updated with new rows on a very high rate (Its a telecommunication application), so we don't want to query select statements so often to avoid any possible probelm.We have another database .i.e MS SQL server, we need to import data from Oracle to MS SQL server on daily basis during late night hours when pressure on Oracle is bit reduced.I need suggestions and comments how best we can do it, I have heard a bit about MSSQL transformation services. Will this help us or any C# program to update data on MS SQL from ORACLE. Thank you@Asteroid |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-01-28 : 05:27:55
|
| Why don't u like to use REPLICATION from ORACLE to SQL SERVER |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-28 : 07:02:34
|
| or schedule a job to execute a dts/ssis package which does data transfer from sql server to oracle. |
|
|
|
Asteroid
Starting Member
13 Posts |
Posted - 2009-01-28 : 08:28:01
|
| @lionofdezert / visakh16, THX for the replies.Well, which one will be most appropriate, and if i get some tips to implement. 1.Planned DTS package to transfer data from Oracle.2.Replication.Thank youAsteroid |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Import data SQL server to Oracle (DTS)