I did a new install of Progression 7.6.400 on a SQL 2005 Server. I noticed that the demodata and screens databases are set to SQL 7 compatibility level. The PWE database is set to SQL 2005 compatibility level. When I restore databases from my SQL 2000 Server, those databases are set to SQL 2000 compatibility level. What level should these databases be set at on SQL 2005? Or does it matter? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Database Compatibility Level in SQL 2005
- Thread starter Maz61
- Start date
You can set the compatibility level to SQL 2005 (90). Progression won't take advantage of it however.
Macola/Synergy/Event Manager/SQL/Crystal tech
Macola/Synergy/Event Manager/SQL/Crystal tech
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question