SDL Trados Studio
SDL Trados GroupShare
SDL Trados Business Manager
SDL Trados Live
SDL Speech to Text
SDL Managed Translation - Enterprise
Translation Management Connectors
SDL LiveContent S1000D
SDL Contenta S1000D
SDL Tridion Docs
SDL Tridion Sites
SDL Content Assistant
SDL Machine Translation Cloud
SDL Machine Translation Connectors
SDL Machine Translation Edge
Tridion Docs Developers
SDL User Experience
Language Products - GCS Internal Community
SDL Community Internal Group
SDL Access Customer Portal
SDL Professional Services
SDL Training & Certification
Language Technology Partner Group
SDL Academic Partners
SDL Enterprise Technology Partners
ETUG (European Trados User Group) Public Information
Machine Translation User Group
Nordic SDL Tridion Docs User Group
SDL Tridion UK Meetup
SDL Tridion User Group New England
SDL Tridion West Coast User Group
SDL WorldServer User Group
Tridion Docs Europe & APAC User Group
Tridion User Group Benelux
Tridion User Group Ohio Valley
SDL MultiTerm Ideas
SDL Passolo Ideas
SDL Trados GroupShare Ideas
SDL Trados Studio Ideas
SDL Machine Translation Cloud Ideas
SDL Machine Translation Edge Ideas
SDL Language Cloud TMS Ideas
SDL Language Cloud Terminology Ideas
SDL Language Cloud Online Editor Ideas
SDL Managed Translation - Enterprise Ideas
SDL TMS Ideas
SDL WorldServer Ideas
SDL Tridion Docs Ideas
SDL Tridion Sites Ideas
SDL LiveContent S1000D Ideas
SDL Contenta S1000D
SDL XPP Ideas
Events & Webinars
To SDL Documentation
To SDL Support
What's New in SDL
We have almost 195000 dita files and maps & images (1 GB of dita files & 1.75 GB of Images). We are using Content Importer to load those files to our DEV environment.
It takes around 9 days to load the whole content. In this cutting edge of technologies and agile world, 9 days are too much.
Seems this is not an acceptable duration. What we can do to speed up this loading process?
(Please do not suggest to chunk our content into multiple sizes we cannot do as we have a lot of cyclical dependencies.)
Suggestions are most welcome. Thanks in advance.
Do you have access to the database servers? If so, export the content of the production database and import it into the development database. The whole process takes about 30 minutes. I do this periodically when I want to make the development environment a "clone" of the production environment, blowing away what's currently in the development database.
I've included our process as a reference. But if I've learned only two things about databases, it's these:
A. ON THE PRODUCTION DATABASE SERVER:
1. Log into the production database and create a .dmp file.
expdp isource/<password> DUMPFILE=proddb.dmp DIRECTORY=dmpdir SCHEMAS=isource
2. Copy the file to the development database server.
B. ON THE DEVELOPMENT DATABASE SERVER:
1. Make sure the following files exist:
2. From SQLPlus, drop and recreate the isource user.
sqlplus / as sysdbadrop user isource cascade;@/u01/install/isrcuser.i
(If the second command returns ORA-01940: cannot drop a user that is currently connected, then run shutdown immediate; followed by startup; and retry the command.)
ORA-01940: cannot drop a user that is currently connected
3. Grant read/write permissions on dmpdir to isource user.
grant read, write on directory dmpdir TO isource;grant all privileges to isource; /* Only do this if you run into permission errors later */
4. Connect to the isource user, run the catdbsyn.sql file, and exit SQLPlus.
5. Import the database.
impdp isource/<password> DUMPFILE=proddb.dmp DIRECTORY=dmpdir SCHEMAS=isource
6. Start the database and exit SQLPlus.
sqlplus / as sysdbastartup;exit;
7. Restart the listener.
8. On the application server: