Maggi19
Member
Hi,
We installed JDE OneWorld e900 on new servers with SQL Server 2008/R2 with collation SQL_Latin1_General_CP1_CI_AS ,when we ran e900 platform pack on new database server it created all the databases with Latin1_General_CI_AS_WS.
1. The system databases (Master, model, msdb. tempdb) were installed with SQL_Latin1_General_CP1_CI_AS.
2. The installation planner (e900) created all databases with Latin1_General_CI_AS_WS.
3. When we refresh e900/JDE_DEVELOPMENT database with e812/ JDE_DEVELOPMENT. It changed the collation on e900 dev database to SQL_Latin1_General_CP1_CI_AS.
Now my system (Master, model, msdb. tempdb databases), business and Central/system databases are on different collations.
Will it be a problem if my business data on collation SQL_Latin1_General_CP1_CI_AS and Central/system databases are on Latin1_General_CI_AS_WS?
Does it cause any issue while running the upgrade plan from e812/SQL2005 to e900/SQL2008 because e812 is on collation SQL_Latin1_General_CP1_CI_AS and e900 central and system databases are on Latin1_General_CI_AS_WS?
Thanks for your help in advance!!
Regards,Maggi
We installed JDE OneWorld e900 on new servers with SQL Server 2008/R2 with collation SQL_Latin1_General_CP1_CI_AS ,when we ran e900 platform pack on new database server it created all the databases with Latin1_General_CI_AS_WS.
1. The system databases (Master, model, msdb. tempdb) were installed with SQL_Latin1_General_CP1_CI_AS.
2. The installation planner (e900) created all databases with Latin1_General_CI_AS_WS.
3. When we refresh e900/JDE_DEVELOPMENT database with e812/ JDE_DEVELOPMENT. It changed the collation on e900 dev database to SQL_Latin1_General_CP1_CI_AS.
Now my system (Master, model, msdb. tempdb databases), business and Central/system databases are on different collations.
Will it be a problem if my business data on collation SQL_Latin1_General_CP1_CI_AS and Central/system databases are on Latin1_General_CI_AS_WS?
Does it cause any issue while running the upgrade plan from e812/SQL2005 to e900/SQL2008 because e812 is on collation SQL_Latin1_General_CP1_CI_AS and e900 central and system databases are on Latin1_General_CI_AS_WS?
Thanks for your help in advance!!
Regards,Maggi