We have to do a migration from adobe day to Tridion. all content is in xml format. Any migration utility is available for the same? and can we store all migrated content in Tridion? do we need any other product to store the content.
No, there is no first-party (SDL) migration tool from other Content Management Systems into SDL Tridion.
I've spoken with one vendor that said it can handle importing at an SDL conference. They did not know what BluePrinting was, so be careful with any third-party vendor that promises a tool.
You really should understand Tridion's content model before moving content in from any system (i.e. get training, please). Content will be stored in Tridion's database, but you should not put it there directly. Doing database updates directly against the Content Manager can (most likely will) invalidate Support for that system.
You, a business analyst, or a functional consultant should evaluate the existing and proposed (Tridion) content model and choose either:
This being said, there have been plenty of migrations from other formats. Your team can seek the assistance of SDL Professional Services, partners, or independent groups that have Tridion expertise.
Final tip: I've never seen a one-time import process. Expect a few iterations as content model and requirements change, especially with somewhat unstructured content (e.g. changing an
h2 in rich text into an actual field gets complicated fast with syntax errors, missing HTML, etc.).