database migration tools for Oracle -> MSSQL

[Steffen Becker]

I want to switch the database for my existing Confluence instance.

As I have large data, the XML backup & restore scenario does not work.

So first of all, can I just do the following:

1. Prepare the new database
2. Stop Confluence
3. migrate database content from current DB (Oracle) to new DB (MSSQL)
4. Change database connections string in my confluence.cfg.xml
5. Start Confluence

My questions:

• Is there something more I have to keep in mind?
• What migration tool can you suggest for step #3 ?