|
-
1.7 gigs is my dev box. My production export is taking 1hour and 45 mins and is a shade over 3Gigs. Now, I know the time issue is because I am exporting a read-consistent version of the database while users are still on. So, on migration day, the export will speed up once I kick all users off.
Full Import is taking about 45mins or so. I am not worried about that. I can't really shave time there. But, if I can cut that export time in half, let say 45mins vice 100, then thats good. I am a 24x7 shop and I am trying to minimize the down time.
I will be doing an export both full and rows=n off my test box before we wipe it and bring in the production data. I am currently doing up a version of my instance on my desktop so I can use TOAD to do a schema comparison after we are done. If I can get my second server up and going by end of month, will be a comparison version on it.
Sorry, not sure what constraints(R.I.) is so can;t tell ya.
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
|