Jazz 4.0.4 to 6.0.5 database import
I am aware that it is recommended to upgrade to 5 before upgrading to 6, however, this is not possible in our environment. I am not allowed to create a test environment to upgrade to 5 first, then to 6.
That being said, our 4.0.4 instance is on MSSQL server 2008, and our new instance is on MSSQL 2012.
Is there any ad hoc way to get this accomplished?
To summarize:
Jazz 4.0.4 databases on MSSQL 2008 server
jts
ccm
rm
qm
dw
need to be imported to
Jazz 6.0.5 databases on MSSQL 2012 server
jts
ccm
rm
qm
dw
Without being able to have an upgrade to 5 environment. Most likely will have to be done manually?
Any insight you can provide is greatly appreciated.
2 answers
I believe you MUST go through V5 to get to V6. There is no other option, since there are data migration handlers that must run in V5 so that additional data migration can run going from V5 to V6.
>>> I am not allowed to create a test environment to upgrade to 5 first, then to 6.
You need to go and get permission, funding, whatever.
>> Is there any way I can get the data migration scripts for v4 to v5, and v5 to v6?
Someone else more hands-on will need to comment on that.
>> I am able to get SQL server space for this, I just cannot get app server space for an install of v5.
I strongly recommend you validate the migration to V5 before starting migration to V6.
Also I recommend this: as a risk reduction exercise, many of our customers do a trial migration before migrating their production data. This gives them the opportunity to validate their migration steps and clear up any questions ... as well as verify that their data migrated OK.