Pulling data from Oracle Database

Pardon me if this is a stupid question but I am very much a newbie at this
sort of stuff. Is it possible to pull data from an Oracle database and
populate a SQL Server 2000 database. I am not sure if I need some sort of
push\pull subsciption or use DTS. Can someonel please help me by providing
some advise or to point me in the direction to find the answers I am looking
for.
Thank you
Paul
I'm not an Oracle guru, so this is just pointers, as I have it setup.
You need the Oracle client setup on the server, then create a linked server
to the Oracle DB, and do a select into.
There are issue's in translation etc. But I have it working at a basic
level, runs automatically monthly to refresh the SQL Server DW.
KlK, MCSE
"Paul Glickenhaus" wrote:

> Pardon me if this is a stupid question but I am very much a newbie at this
> sort of stuff. Is it possible to pull data from an Oracle database and
> populate a SQL Server 2000 database. I am not sure if I need some sort of
> push\pull subsciption or use DTS. Can someonel please help me by providing
> some advise or to point me in the direction to find the answers I am looking
> for.
> Thank you
> Paul

Pulling data from Oracle Database

Pardon me if this is a stupid question but I am very much a newbie at this
sort of stuff. Is it possible to pull data from an Oracle database and
populate a SQL Server 2000 database. I am not sure if I need some sort of
push\pull subsciption or use DTS. Can someonel please help me by providing
some advise or to point me in the direction to find the answers I am looking
for.
Thank you
PaulI'm not an Oracle guru, so this is just pointers, as I have it setup.
You need the Oracle client setup on the server, then create a linked server
to the Oracle DB, and do a select into.
There are issue's in translation etc. But I have it working at a basic
level, runs automatically monthly to refresh the SQL Server DW.
KlK, MCSE
"Paul Glickenhaus" wrote:

> Pardon me if this is a stupid question but I am very much a newbie at this
> sort of stuff. Is it possible to pull data from an Oracle database and
> populate a SQL Server 2000 database. I am not sure if I need some sort of
> push\pull subsciption or use DTS. Can someonel please help me by providin
g
> some advise or to point me in the direction to find the answers I am looki
ng
> for.
> Thank you
> Paul