Primavera (MOSC)

MOSC Banner

P6 migrate.bat from Oracle to SQL Server fails with DatabaseToolException sp_dbcomptlevel

in Primavera (MOSC) 1 commentAnswered

I am migrating an old P6.7 database from Oracle to SQL Server. The migrate.bat tool delivered with the software fails with sspm_init_db.sql: DatabaseToolException (Usage: sp_dbcmptlevel )

sspm_init_db.sql is hard coded with "exec sp_dbcmptlevel @dbname=@DB_NAME,@new_cmptlevel=80".

I tried updating sspm_init_db.sql with @new_cmptlevel=100, but the migrate.bat process still uses 80.

80 must also be hard coded in the java class files. I am looking for a workaround to force this migrate.bat to new_cmptlevel=100.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center