Migration of Database for Documentum 16.4 from Oracle 12c to Sql Server

SandipDabhade

Dear All,

we want to change our database from oracle to sql, we have decided following approach.

1) Setup Sql Server
2) Migrate Schema and Data using SSMA tool from oracle to SQL
3) Setup Content Server and create repository using migrated database.

Now the problem is documentum expects SQL Server in case sensitive mode, while migrating schema from oracle to sql all tables and columns are getting converted to UPPER case in sql server and when I am setting up repository using migrated schema documentum creating duplicate tables in lower case.

Any idea how can we migrate from oracle to sql using SSMA and migrate schema in lower ?

shoeb_haque

Last time I evaluated SSMA, we discovered issues with conversion of date attributes from Ora to SQL also. As pointed by others, consider a migration utility or contacting Professional Services.

rkavanagh

You may want to consider an OpenText solution called ContentBridge. This has functionality to read from one Documentum system and import to another. So you could have your original as the source and setup a new repository with your target OS/DB as your target repository.

SandipDabhade

With SSMA and Stored procedures i managed to migrate schema, data and converted the names,columns in lower case

SandipDabhade

SandipDabhade

Getting this error while start