Migrate eB database from Oracle to SQL

Hi Everyone !!

I need to migrate the eB Database from Oracle 11g to SQL2008. In my research I have founded a SQL tool called "Server Migration Assistant" (SMA). I was able to migrate all tables, but I´m having some errors from eB SMC saying that column types are not OK.

Have anyone done this before ? Do anyone have some documnetation about column/data types on eB ?

Many thanks in advance

Greetings,

Ezequiel.

Parents
  • Hello Ezequiel,
    I do think that better approach would be by using provisioning spreadsheets for this kind of work. It does work with Oracle and MS SQL so data can be migrated from one type db to another.

    Gintautas



  • It´s not that simple. It is a comunity with a lot of folders, and documents related to those folders, so via Spreadsheets this can´t be done. But don´t worry we have already find a way to do it. As I said before we use SSMA for Oracle, for converting data from Oracle to SQL using a temporary database, then we deployed a clean eB database using SMC, and then via scripts we copied out all the data from the tables in the temporary database to the tables in the clean new eB database (first we disbaled all constraints in the target database, and when the process finished we enabled all constraints again). Now we have a migrated eB from Oracle to SQL fully functional.

    Thanks.
    Ezequiel.
Reply
  • It´s not that simple. It is a comunity with a lot of folders, and documents related to those folders, so via Spreadsheets this can´t be done. But don´t worry we have already find a way to do it. As I said before we use SSMA for Oracle, for converting data from Oracle to SQL using a temporary database, then we deployed a clean eB database using SMC, and then via scripts we copied out all the data from the tables in the temporary database to the tables in the clean new eB database (first we disbaled all constraints in the target database, and when the process finished we enabled all constraints again). Now we have a migrated eB from Oracle to SQL fully functional.

    Thanks.
    Ezequiel.
Children