Migrating data from SQL Server to Oracle

You can migrate the data from SQL Server to Oracle and configure the Publishing Document Builder to use the new database.

1. Stop the Publishing Document Builder server that is configured to use the SQL Server database.
2. Migrate the data from the existing SQL Server Database to Oracle by using Oracle SQL Developer as explained in Migrating from Microsoft SQL Server to Oracle guidelines.
3. Configure Publishing Document Builder to use the Oracle database.
   • For WebSphere® Application Server Liberty Profile, see Custom Deployment of Publishing Document Builder on WebSphere Application Server Liberty Profile.
   • For WebSphere Application Server, see Deploying Publishing Document Builder on WebSphere Application Server.
4. Start Publishing Document Builder.