-
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
-
and what is the purpose of the replicated database
-
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.
-
Sounds like data pump :-) Hard to say what is the best method but dp would do that relatively fast and relatively simple
-
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...
-
We are using solaris on both ends.... just want to sync
-
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
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|