I am working on a new project where we would like to eliminate processes that involve bulk loading data extracted from an Oracle 10g database into a SQL Server 2005 database. The extracts come in the form of Excel worksheets. Can I get the data from the Oracle DB directly, through linking or some other method as opposed to loading the data from a worksheet? I'm completely new to this, as our previous DBA\SQL developer left suddenly and I've been tasked with this. Any help would be greatly appreciated.
I think what you are looking for is called Linked Servers. See http://msdn.microsoft.com/en-us/library/ms188279.aspx -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "kiloez" wrote in message news:F36B5EDB-5A36-4EC1-82BA-5D18AC25A451@microsoft.com... >I am working on a new project where we would like to eliminate processes >that > involve bulk loading data extracted from an Oracle 10g database into a SQL > Server 2005 database. The extracts come in the form of Excel worksheets. > Can I get the data from the Oracle DB directly, through linking or some > other > method as opposed to loading the data from a worksheet? I'm completely > new > to this, as our previous DBA\SQL developer left suddenly and I've been > tasked > with this. Any help would be greatly appreciated.
