Hi,

I am using SQL2K and need to import multiple tables (15)
from an oracle DB(production) into Sql Server as a
reporting DB. Instead of doing a Package and a Job for
every table is there a way to make one Package and one Job
for all 15 tables where if one table fails the rest will
continue to import?
Also,
Oracle does use a date/time stamp for record id, so how
can I keep my Sql Server updated as close to real time on
a daily basis. My first thought was a curser but I thought
that deleting all the records (2,000,000)within a table
and re-imporing them would be faster. Does anyone have a
better idea of how to handle this? Which way would it be
faster or is there another way to this? Not only do I have
to worry about new records but also for existing updated
records.
Thank you in advance
Sergio Lopez

When moving data between Oracle and SQL Server in DTS a lot of people like
to

Export to text file
FTP over
Import the text file

You can export from Oracle based on this record id

As for keeping them near real time

Q. How can I develop my own solution for transactional replication
from other data sources to SQL Server?

A. SQL Server provides a programming framework enabling heterogeneous
data sources to update a SQL Server database through transactional
replication. Several third parties, such as Open Universal and Vision
Solutions, have implemented this framework to create products that help
develop in-house solutions







--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sergio Lopez" <anonymous (AT) discussions (DOT) microsoft.com> wrote