Hello,
I have this kind of situation: I have Oracle database from an old application and i have to maje an job to copy it every day into an SQL Server 2005 database. The data should stay in both databases. Is this posible to do it with an job or i have to develop an service? If it is possibe i would like to know how. Is the same possible but from DB2 database to SQL Server 2005 database?
Thanks
Yes its possible. there are many method
(a) Create a linkedserver to Oracledatabase and copy the data : Read Linkedserver In BOL(Books online)
(b) Create a SSIS (Integration Service) package to migrate the data.
(c) Openddatasource
alll these can be scheduled though a job
Madhu
|||
can same be done with DB2 database instead of oracle?
|||yes it can be done. only the provider changes..
Madhu
No comments:
Post a Comment