Results 1 to 8 of 8

Thread: Data Pump

  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Lightbulb Unanswered: Data Pump

    My client is using a sql server 7.0 to store realtime data like heat,temp,pressure etc inserted every second.He wants me to provide a solution to transfer the summarised data to oracle server on a regular basis..say once on every 5 min..

    what approach i should take....help me out pls

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Set up a DTS package to send the data from SQL Server to Oracle.
    Create a scheduled job to run the package every five minutes.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    In SQL Server 2000 replication can solve your problem but I do not know about SQL Server 7.0.

    Blindman's idea is easy & will be work for you...

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I can't recommend that anybody include DTS packages as part of any long-term solution now that SQL Server 2005 no longer supports them.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    I can't recommend that anybody include DTS packages as part of any long-term solution now that SQL Server 2005 no longer supports them.
    I suppose that by the strictest definition that is true, but I tend to think of SSIS as being the descendant of DTS.

    -PatP

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Descendent, bastard child, unholy spawn, however you want to call it...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    Descendent, bastard child, unholy spawn, however you want to call it...
    So, how do you really feel about SSIS? You don't have to hold back, we understand.

    -PatP

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Code:
    select	@Functionality/@Documentation
    
    -----------
    Msg 8134, Level 16, State 1, Line 1
    Divide by zero error encountered.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •