Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Moving SL7 FP1 to new 2012 server with SQL 2012.

Posted on by 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

  • Suggested answer
    Bruce.T Profile Picture
    Bruce.T 405 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans