One easy way is to setup a DTS job to run daily. DTS works great for moving data between SQL Server, Oracle, DB2 and other data sources.

Dave


-----Original Message-----
From: James Habjanetz [mailto:James.[Email Address Removed] Thursday, August 29, 2002 6:15 AM
To: LazyDBA.com Discussion
Subject: SQL Server7 to Oracle 8.1.7


Does anyone know an easy way to extract data from SQL Server 7.0 to an
Oracle Database. I would need to do this daily in an automated process.

Thank You,
Jim

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page