Question on migrating from MSSQL temp tables and remote queries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lev
    #1

    Question on migrating from MSSQL temp tables and remote queries

    Hello,

    I am attempting to migrate an MSSQL server application to Oracle. This
    application pulls in data from remote databases into temp tables and
    then does various joins of that data with local tables.

    There are two requirements: the temp tables cannot be permanent
    members of the schema and application has to be self sufficient in
    create database links - users cannot be asked for that.

    The only solution that comes to mind is to create database links via
    SQL, pull in the data, create the temp tables and then drop the
    created links and temp tables when they are no longer needed. But that
    seems inelegant. Is there a better way?

    Any info is much appreciated. Cheers, Lev.
    Tags: None
    • Jim Kennedy
      #2
      Re: Question on migrating from MSSQL temp tables and remote queries


      "lev" <pelekhl@msn.co m> wrote in message
      news:63dbca9c.0 405240927.2fc37 01e@posting.goo gle.com...[color=blue]
      > Hello,
      >
      > I am attempting to migrate an MSSQL server application to Oracle. This
      > application pulls in data from remote databases into temp tables and
      > then does various joins of that data with local tables.
      >
      > There are two requirements: the temp tables cannot be permanent
      > members of the schema and application has to be self sufficient in
      > create database links - users cannot be asked for that.
      >
      > The only solution that comes to mind is to create database links via
      > SQL, pull in the data, create the temp tables and then drop the
      > created links and temp tables when they are no longer needed. But that
      > seems inelegant. Is there a better way?
      >
      > Any info is much appreciated. Cheers, Lev.[/color]

      Why are the requirements such? Do we have the tyranny of the requirement of
      a genuine business need? Describe the problems that you are trying to solve
      instead of how to implement a solution. There may be a better solution.
      Jim


        Comment

        • lev
          #3
          Re: Question on migrating from MSSQL temp tables and remote queries

          >[color=blue]
          > Why are the requirements such? Do we have the tyranny of the requirement of
          > a genuine business need? Describe the problems that you are trying to solve
          > instead of how to implement a solution. There may be a better solution.
          > Jim[/color]

          Jim,

          This is a commercial software product, and history shows that the
          average customer gets very upset if the schema is changed from
          previous version or if any if accessive manual database administration
          is involved. In this appliction there can be many databases involved,
          and all need to exchange data. This would require a creation of N^2
          database links - something we are trying to avoid.

          Thanks.

          Lev.

            Comment

            Previous template Next
            Working...