I�m need some advice. I have a few tables in Oracle 9i that I need to
get into SQL Server 7 daily and when needed, the basic function of the
process is get the data from Oracle then perform some joins followed by
creating a new table in SQL Server with the results each time this job
is run.
What�s the best way to do this? Right now I have a CFMX server with a
JDBC connection to Oracle then I CFQUERY my way through this task using
a CFM template. I was thinking if I could use a SQL Server SPROC this
might be a better method.
Does anyone out here do anything like this? By what I�ve been
researching using a SQL Server �Linked Server� may be the option I�m
looking for.
Regards,
-JB
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
