on 06-17-2009 11:55 AM
Dears,
I need to export two tables from PRD and import to QAS.
Size of table is 1 GB and 3 GB.
Please confirm:
1--Do i need any downtime for export and import of table
2- How much time will it take in this export process.
Please suggest.
Shivam
1. it is better to get downtime, but, depending on the system's usage, it might not be needed. You jsut do not want to export while this table is being used.
2. it is impossible to answer, we do not know your hardware config, we do not know which tables you are trying to export. but usually, exports are fast and imports are much slower.
you know that this is not really supported and may even wreck your destination system?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I cannot tell you how much time it will take. are you still using Pentium 3 processors? are you on 4 quad-core CPU? are you on IDE disk? SATA disks? on a fast and big powerful SAN?
This being said, I would say roughly 10 minutes. but as you understand, this is just a wild guess.
for downtime, you did not tell us the table names. This being said, try to export on a low usage period.
I dont think you will get answer on runtimes for import/export as it depends on your system configuration. Please also remember importing only selected tables may lead to inconsistancy in your db unless you know these tables are isolated from tables relation perspective. You may want to plan this during quite time like over the weekends.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.