Moving SL7 FP1 to new 2012 server with SQL 2012.

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have an older firm who is trying to move their Dynamics SL7 FP1 to a new server and SQL cluster. The servers are 2012 R2 and the SQL server is also 2012 and are patched to current. They also have FRx6.7 that is being used but it is SP 9. I am told that these older versions do not support 64 bit servers. Are there any workarounds?

Respectfully submitted,

RayJPeters

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

Bruce.T 405 on at

Like (0)

Report
RE: Moving SL7 FP1 to new 2012 server with SQL 2012.

Hi Alex,

We are currently migrating from SL7 to SL2015 CU2.

We have found that there isn't a significant training requirement. The major things are:

Active applications pane is no longer available - the icons in the task bar must be used instead

Changing company process is different - opening another company no longer closes the current company therefore the same form can now be open in several companies at the same time

Business date is retained on change of company (ie not reset to current date as it does in SL7)

Crystal reports parameters look very different

PV lookups provide improved selection options

There is a new option to search for a screen/report etc from the main menu - very useful for new or infrequent users

Quick Query is available

From a technical perspective:

"Set Nocount on" must be used on all customisations and Crystal reports

Crystal reports selection SQL and parameters must be in Crystal language not Transactional SQL they could in SL7 eg database fields must be enclosed in {}

Less options to export from a Crystal report eg txt and ttx no longer available

We have had to make changes to every Crystal report with parameters to accommodate changes to how these are managed and displayed

That's all I can think of at present
Community Member Microsoft Employee on at

Like (0)

Report

RE: Moving SL7 FP1 to new 2012 server with SQL 2012.

Thanks for the information. I have found out since that the client. (Due to support with SL7 being ended soon) Are looking at upgrading to 2015. Any issues that you found and does the interface require retraining for the personnel involved.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Moving SL7 FP1 to new 2012 server with SQL 2012.

All of the above works: WIndows 10 @ 64bit, runs dynamics with FRX 6.7 without issue. (installed from server share, not installed locally)

recently upgraded SL7 to 2015 CU1 on windows server 2012, and sql server 2014.

frx 6.7 (with maxed out ServicePack)

Forecaster requires a 32bit tweak, but it works too.

we are going towards Bi360 to get rid of Frx in the future.