2

If the source CME is using SQL Server and the target SME is on Oracle, will I anticipate any issues migrating content from SQL server CME to Oracle CME via Content Porter?

2

Note that Content Porter is not intended for database migration purposes. It doesn't port all data in the system, you loose version histories and you will hit size limitations if you try to export your entire CM system.

If you only want to port a limited number of items (and don't care about the functional limitations), there should be no issues with different DB types for the source and target systems.

| improve this answer | |
3

I would not expect any issue because the Content Porter calls the Tridion Core Service API which is an abstract layer on top of the database.

However I did not try it myself so will let others detail their experiences.

Is this for a migration or do you have disparate systems in your DTAP setup? I would not recommend the latter.

| improve this answer | |
  • Ok. Sorry late to respond to my own post. I didn't expect any issues either, however I have never been through an implementation of this kind before. This is simply for migration. – Andrew William Ross Feb 24 '15 at 15:10
3

The problems you may spot are related to database and not to Tridion per se. Even more you might have problems migrating between the databases of the same type. For example: you may have different character set, this might result in some exotic characters being displayed differently or maximum name of an item be slightly shorter on one of the databases if use Chinese characters. But there should be no functional difference. If both databases are being setup according to Tridion installation manual, the only problem I foresee are slightly shorter item names on Oracle if use asian symbols

| improve this answer | |
  • I concur on these, I never saw issues during the import (or export for that matter), but did see differences in the system afterwards (like the way a list is alphabetically ordered can be different on Oracle because there is a setting for it, although those differences you could also see on different MS SQL Server instances). – Bart Koopman Feb 24 '15 at 9:10
  • Appreciate the insight. My understanding was also that as long as you’re using compatible version of Content Porter for both source & target systems. It doesn’t matter with the backend. – Andrew William Ross Feb 24 '15 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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