Hi All, I was wondering if i can load data from oracle DB to MS-SQLserver using a script or something that can be scheduled as i want to do this on daily basis in order to get the updated data for the new day.Any help??
thanks in advance
asked
Can I load data from oracle DB into MS-Sql server on daily basis?
If you are using 32 bit SQL Server, then you can get the drivers to set up a linked server and set up a job to pull the data. You need to provide more information about versions, operating systems etc before anyone can give you more information as it does make a difference.
Another alternative solution is to use SSIS packages as scheduled jobs. Under data flow tasks one can set the OLEDB Source to oracle and pull the needed data. This solution is out-of-the-box in this product.
And either a direct INSERT/UPDATE using linked servers as mentioned by RickD, or the use of SSIS (or DTS in older versions) as mentioned by Rajib can be setup to be executed on a regular basis by using a Scheduled Job.
