You have the option to use either Microsoft SQL or Oracle Database. However, there is no direct conversion from a Microsoft SQL database to an Oracle Database; therefore you will need to migrate your content manually. Please note that the following data will be lost as a result of migrating your data: 

Follow these recommended steps to migrate content manually to an Oracle Database:

  1. Upgrade your current installation on the Microsoft SQL server using the steps outlined above. Make sure that all authors have upgraded their client installations as well. This allows the system to update all of the standard styles and templates in the same environment. You will still need to update your customized publishing styles later.
     
  2. Within the Developer, export all documents in the library into several .odarc files, including the System folder. This allows you to replicate your environment from the Microsoft SQL server to the Oracle Database server.
     
  3. Export the content defaults.
     
  4. Install a new instance of 11.1 with an Oracle Database server following the instructions in the Installation & Administration manual for installing a server. You can use the procedure to install the server and database at the same time, or you can follow the procedures for installing the Oracle Database first and then installing the server with an existing Oracle Database. When you install, make sure that you install to a new location and virtual directory.
     
  5. Have the authors create a new profile to log in to the new installation. If you are not using Windows authentication for the authors, log in to the new installation as an administrator and create user accounts for the authors.
     
  6. Within the Developer, import the .odarc files you created in step 2 into the Oracle Database. Since you are importing .odarc files, you can overwrite the documents without causing technical issues.
     
  7. Import the content defaults (step 3).
     
  8. Re-apply any customizations to the publishing styles, basing them on the styles for 11.1.

Table of Contents