DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Best method to transfer Data between Servers

  1. #1
    Join Date
    Oct 2007
    Posts
    5

    Post Best method to transfer Data between Servers

    Which is the best method to transfer data between two servers. Replicate the data or using XML?..or any other method ?

    Requirement: We have two servers reside in two different locations. Both the server have the same set of table structures. we need to transfer the data between the servers

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and what is the purpose of the replicated database

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Size?
    O/S on each end?
    Do you want a periodic snapshot or you want them to be in sync?
    Last edited by PAVB; 10-23-2007 at 07:19 AM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Sounds like data pump :-) Hard to say what is the best method but dp would do that relatively fast and relatively simple

  5. #5
    Join Date
    Oct 2007
    Posts
    5
    Quote Originally Posted by davey23uk
    and what is the purpose of the replicated database
    The replicated database is used for reporting purpose only.... all our branches are in same network, some comes under our newly implimented core system and others under our legazy system... we have one reporting system for both. the legazy system pull the data to the reporting server thru encrypted XML. So we need to load the same data from the new system to the report server...

  6. #6
    Join Date
    Oct 2007
    Posts
    5
    We are using solaris on both ends.... just want to sync

  7. #7
    Join Date
    Oct 2007
    Posts
    5
    Quote Originally Posted by Bore
    Sounds like data pump :-) Hard to say what is the best method but dp would do that relatively fast and relatively simple
    ya, its like data pump... we have the same db structure on both ends, contain 29 tables... 350 branches data and on and averrage 5000 records per branch per day.... the main system on server-1 generates the data to the 29 tables at the time of end of day process, so we need to transfer it to the server-2 contain the same db structure

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    again... what's the total size of your database?.... in Gigs please.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Oct 2007
    Posts
    5
    Quote Originally Posted by PAVB
    again... what's the total size of your database?.... in Gigs please.
    The approximate size of the report database is 180GB, the one day data we need to transfer from the main server to report server is 100MB

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    just setup materialized views and refresh groups

Posting Permissions

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


Click Here to Expand Forum to Full Width