web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / I am upgrading from SL...
Microsoft Dynamics SL (Archived)

I am upgrading from SL 6.5 to SL 2011 and moving to a new DB server after installing sl 2011 and restoring my databases from my old systems, when I run the database maintenance application, the systems lists my system database but it does not list any of t

(0) ShareShare
ReportReport
Posted on by Glen Henry 160

I am upgrading from SL 6.5 to SL 2011 and moving to a new DB server after installing sl 2011 and restoring my databases from my old systems, when I run the database maintenance application, the systems lists my system database but it does not list any of the application databases to upgrade.  Has anyone experienced this? If so what did you do to resolve?

 

I have installed Windows 2008 R2, Microsoft SQL 2008 on a new 64 bit Dell

*This post is locked for comments

I have the same question (0)
  • Verified answer
    John Joyce Profile Picture
    John Joyce 25 on at

    Have you checked the ServerName in the Domain table? It may still reflect the name of the old server.

    Select DatabaseName, ServerName from Domain

    --Update Domain Set ServerName = 'NewServerName' where ServerName = 'OldServerName'

  • Verified answer
    Charlie Ulrich Profile Picture
    Charlie Ulrich 30 on at

    I am in the middle of performing the exact same upgrade.

    There are many pitfalls along the way, especially if you are running business portal (HINT: you have to upgrade to 7.0 then to 2011 there is no direct path from 6.5 to 2011 if you are upgrading business portal as well).

    Following moving the databases I would run the following queries against the systems database from SQL Management Studio:

    1. Update Tables with New SQL Server Name - mbs2.microsoft.com/.../kbdisplay.aspx

    UPDATE DOMAIN SET Servername = 'YOUR_NEW_SQL_SERVERNAME'

    2. Clear out old registration information - mbs2.microsoft.com/.../kbdisplay.aspx

    DELETE from REGISTRATION

    DELETE from REGISTDETAIL

    3. Clear out Customizations

    The upgrade docs tell you to export your customizations prior to upgrade and then reimport them.  I was having some strange issues with mine, so I ended up just clearing them all out and rebuilding them.  To do that run the following queries

    delete from custom

    delete from custom2

    delete from customvba

  • Glen Henry Profile Picture
    Glen Henry 160 on at

    This did solve my problem, I also made the change in the Company table

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    The issue is that in SQL, the Domain table in the system DB doen't see the new server. You have to have the new server  there and in the Company table in the system DB.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans