Clarity

Is it possible to migrate from a pilot environment which is on-permise/13.1/MS-SQL to a production environment which is on-demand/13.2/Oracle-DB by database migration or will we have to use XOG? Thanks

XOG will be the way.

(there are many reasons why a DB "migration" would not work; not least of which is that even if you could technically achieve this, it would be unsupported, especially on-demand)

If you are basically asking if you can do something like a db backup of ms sql and restore it into another version in Oracle to a system where you do not have a system level access  or if there are tools in Clarity or third party tools for that the answer is no as Dave already answered. Even with an on premise and using the same database the version hop may give hickups.

This has been asked for more than once. Search the message boards.

What you can do is XOG out what you can as Dave posted.  You can get further than that with SQL queries with or without portlets. That is for reading the data out.

The writing of more than standard XOG xml data is possible with GEL scripts or tools that use GEL. However, with on demand the tools has to be such that requires no install on the server and works on the client only.

There are commerical third party tools and CA Services Data Migration tool, but I am afraid they require installation on the server but not sure of that. Secondly the price may not be justified for a single migration.

Martti K.

Thanks Martti an Dave. (Don't know why "Enter" key doesn't work for me in this site). Your replies direct me to XOG. Since the customer was on pilot, they haven't generate much functionality to transfer. The most important thing is the project actuals. Does it pass with the progect when XOGing? Is there something specific I need to pay attention to? Thanks, Barak

Looking at the rpoject_write sample file the actuals are there at the assignment level.

If you read out first then you don't have to figure out which numbers to use.

Martti K.

        <!--Task name="Effort" taskID="effortID" outlineLevel="1" delete="true"/-->
        <Task name="task1" taskID="taskID1" outlineLevel="1" start="2003-01-01T00:00:00" baseStart="2003-01-01T00:00:00" finish="2003-06-01T00:00:00" baseFinish="2003-06-01T00:00:00" milestone="true" summary="true" key="true" category="b2b" status="1" percComp=".1" priority="5" earlyStart="2003-01-01T00:00:00" earlyFinish="2003-06-01T00:00:00" lateStart="2003-02-01T00:00:00" lateFinish="2003-08-01T00:00:00" duration="7" baselineDuration="6" shortName="fisrttask" guidelines="see project plan" fixed="true" baseFixed="true" baseTime="2003-01-01T00:00:00"/>
        <Task name="task2" taskID="taskID2" outlineLevel="2" start="2003-01-01T00:00:00" baseStart="2003-01-01T00:00:00" finish="2003-06-01T00:00:00" baseFinish="2003-06-01T00:00:00" milestone="false" summary="false" key="false" category="b2b" status="1" percComp=".5" priority="10" earlyStart="2003-01-01T00:00:00" earlyFinish="2003-06-01T00:00:00" lateStart="2003-02-01T00:00:00" lateFinish="2003-08-01T00:00:00" duration="7" baselineDuration="6" shortName="fisrttask" guidelines="see project plan" fixed="false" baseFixed="false" baseTime="2003-01-01T00:00:00"/>
        <Task name="task3" taskID="taskID3" outlineLevel="1">
          <Assignments>
            <TaskLabor resourceID="joeTime" actualThrough="2003-01-01T00:00:00" estPattern="2" basePattern="3" estMax="1" baseMax="2" pendEstSum="6" pendActSum="4" pendStart="2003-02-01T00:00:00" pendFinish="2004-01-01T00:00:00">
              <Curve>
                <Segment start="2003-01-01T00:00:00" finish="2003-03-01T00:00:00" sum="5"/>
                <Segment start="2003-04-01T00:00:00" finish="2003-06-01T00:00:00" sum="4"/>
              </Curve>
            </TaskLabor>
          </Assignments>
        </Task>