Take the 2-minute tour ×
Tridion Stack Exchange is a question and answer site for Tridion developers and administrators. It's 100% free, no registration required.

I am living with a system where Dynamic CP are configured to published to the File System instead of the Broker DB. I would like to change this from File System to the Broker DB, but the catch is that, I do not want to to re-publish items.

I know, I can do this by changing configuration/storage ID in the Broker Configuration file, but I really do not want to publish the millions of the items for 100 of websites.

Is there some geek way out?

share|improve this question
    
Sometime between R5.3 and 2009 or 2011, the way custom metadata was stored changed from comma separated values to key-value pairs. I wouldn't recommend going the route of a direct database script, but it's worth knowing the difference between versions (and there may be others). –  Alvin Reyes Aug 11 at 11:23

1 Answer 1

up vote 6 down vote accepted

At the core of your goal, you need to move your millions of items sources from the filesystem into the database. You can either choose to do that using the tridion mechanisms (i.e. publishing), or you can write your own migration scripts that take the contents of the filesystem files and insert them into the correct DB tables. I would be very carefull in choosing the latter because you have to take great care in ensuring that your DCPs are able to enter and exit the database without destroying for instance your encoding setup. Personally, i would be happier scripting the republish then i would be scripting the database inserts.

share|improve this answer
    
Thanks Rogier for sharing your thoughts. It is quite helpful. –  Pankaj Gaur Aug 11 at 10:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.