Who's On?

	Membership:
	Latest: Isabella Harris
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5233

	People Online:
	Visitors: 440
	Members: 0
	Total: 440

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Upgrading SQL from 2000 to 2005 or 2008 on LSF 9.00X

7 Replies

0 Subscribed to this topic

27 Subscribed to this forum

Sort:

Author

Messages

Joe O'Toole

Veteran Member

Posts: 314

8/6/2010 4:04 PM

I'm planning an update of our LSF from 9.004 to 9.009 and since the sleeves will be rolled up, upgrade our SQL 2000 instance as well. I've heard rumors about SQL 2008 quirks and wanted to hear about anyones experiences who has done this. Our SQL 2005 is Standard edition and will not install on top of our 2000 Enterprise instance. Our 2008 is Enterprise so it should be able to install as an upgrade. Thanks for any info.

Joe O'Toole

Veteran Member

Posts: 314

8/6/2010 5:53 PM

I wanted to add that the main reason we were considering 2005 was the Backward Compatibility Pack that provides DTS support as we have quite a few DTS packages written. It appears that this pack is also available for SQL 2008 so that no longer should be a factor in the decision.

Jimmy Chiu

Veteran Member

Posts: 641

8/6/2010 7:02 PM

Have you checked the compatibility matrix? The older OS running lawson does not support SQL 2008.

Joe O'Toole

Veteran Member

Posts: 314

8/6/2010 7:11 PM

Actually, I didn't mention my OS version - it is Windows 2003 R2.
According to page 11 of the matrix I have dated April 26, 2010 Windows 2003R2 is compatible with LSF 9.007 and SQL 2008. Are you looking at something different?

Jimmy Chiu

Veteran Member

Posts: 641

8/10/2010 3:08 PM

Windows 2003 doesn't support SQL 2008 according to what you looked at. Windows 2003 R2 does however.

Joe O'Toole

Veteran Member

Posts: 314

8/10/2010 4:35 PM

I was speaking with a Lawson engineer today and they confirmed that SQL 2008 will work on my system which is Windows 2003 R2 and (will be shortly) LSF 9.0.0.9.

ChadH

Basic Member

Posts: 5

12/15/2010 8:19 PM

Does anyone know about the compatability of SQL 2008 SP2 with Lawson 9.0.1.6?

ChadH

Basic Member

Posts: 5

12/16/2010 1:09 PM

If anyone was curious or needed to know, just got done speaking with the Lawson tech staff and they stated that SQL2008 SP2 did not interfere with functions of LSF9.0.1.6.