aren't exclusive. If you're really worried about
speed, then you should definitely cut CF out of the
loop and have SQL Server pull the data directly from
Oracle.
If you have SQL Server talk to Oracle directly, then
you will probably need to set up an Oracle connection
for your SQL Server database, as your article says.
See http://www.orafaq.com/faqodbc.htm for more
details.
Unless you need real-time data, for performance
issues, it's better to make a local copy of the Oracle
table(s) that you need rather than having to fetch the
table across the network all the time. Again, this
scheduled import is best done with DTS.
--- James Blaha <[EMAIL PROTECTED]> wrote:
> Aaron,
>
> Check this out:
>
>
http://www.winnetmag.com/SQLServer/Article/ArticleID/22264/SQLServer_22264.html
>
> Regards,
> -JB
>
> Aaron Rouse wrote:
>
> > Why do you need to execute the DTS from CFMX? I
> suppose you could do
> > a combination of DTS and stored procedures. I
> personally have never
> > used an SP to connect to another flavor database
> and pull out date,
> > honestly not even sure how that would be done, so
> could not say if it
> > is faster or not to do it solely through an SP.
> >
> > On Tue, 10 Aug 2004 11:25:13 -0400, James Blaha
> <[EMAIL PROTECTED]> wrote:
> > > My first thought was DTS but aren't SPROCs much
> faster to execute? Plus
> > > I need to execute the DTS via a Cold Fusion
> template I know how to due
> > > this but I always run through loops with my DBA
> about the setup with all
> > > the permissions I need to have setup.
> > >
> > > Regards,
> > > -JB
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
