Post reply

Is there a better way?

  • November 9, 2005 at 3:42 am

    #92087

    Currently I have an OLAP system in SQL 2000 which has an orders table updated hourly via a sproc through a linked server connection to the Oracle OLTP system.

    Is there a better or smarter way of doing this? It currently works but as it runs only once an hour is not exactly 'real time'.

    Any thoughts or suggestions would be greatly appreciated.

  • November 9, 2005 at 9:59 am

    #603066

    You can setup your sproc to execute at shorter intervals, or have your SQL Server subscribe to a replicated copy of your Oracle table(s) - this is less resource intensive on the OLTP db.

    Regards,

    ChrisB MCDBA OCP MyDatabaseAdmin.com

    Chris Becker bcsdata.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply