[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Dynamics v8 transfer to another server

Posted on 2013-05-11
Medium Priority
Last Modified: 2016-11-23
I have a problem with an "old" server that is dying. Windows Server SBS 2003, Dynamics 8, SQL 2000. We DO NOT have any money to go out and buy all new software and hardware. However when we bought these Dell 2800's we got two of them--one for production and another for a hardware backup, After 10 years we will hope to get a use of the backup. So my question is if I install Server 2003 SBS and then install Dynamics and SQL can I then "simply" copy the Dynamics install from the old server to the new install? If I  setup SQL to store the databases in the same place so that when Dynamics starts it is setup on the "same" hardware albeit it different hardware, will that work? Or is the Dynamics install much too complicated to do it like this? Or will have I have to export registry settings and/or something else to get this functioning. We do not have the money to hire a Dynamics expert to do this transfer for us, so I was hoping this "simple" process might work--will it? Thanks!
Question by:Lionel MM
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 27

Expert Comment

by:Chinmay Patel
ID: 39158652
Hi lionelmm,

I don't think that will work.  I am not  an expert in this area so you might want to wait for other experts to  respond.

LVL 25

Author Comment

by:Lionel MM
ID: 39240837
Thank you.
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 39300791
This seems to have been posted quite a long time ago, but thought I'd respond anyhow.

If you are going to move your exact installation to another identical server then you can simply backup and restore.  The easiest way to do this would be to use a full image backup such as Acronis, but the built-in SBS backup should do the trick.

Just follow the documentation:

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 39300794
I would point out that all of your software is beyond the general support life-cycle, so you will really be stuck should you have any problems in the future.  Best to get it upgraded, or look at alternative cloud-based solutions which do not require such a large investment.

LVL 25

Author Comment

by:Lionel MM
ID: 39301720
Thanks for that but in the question I did note that we do not have any money for this--we have to make do with what we have, and cannot upgrade--even to cloud based solution. Worst case we will do a ASR to the backup server--that will be our fail back, last option solution but since we are going to do this I wanted to do a fresh install of Windows Server and then of SQL and then of Dynamics. After 10 years of use all operating systems have their issues and so I wanted to find out how best to proceed to move an existing SQL/Dynamics from one server to another. Since posting this Q I have found several helpful postings and it is possible--do you have any experience doing this? I have actually started the process, having put together a server of spare parts for testing purposes and have SQL in the same sate as the old server, same updates, same service packs--first requirement. Next is to create databases in the same order as the original--trying to find out that order from their IDs--stuck here for now.
LVL 25

Accepted Solution

Lionel MM earned 0 total points
ID: 39320508
After much searching I found this and it works--these are just the basic outlines, there are details and links to other resources missing because it is so much. Not easy to do but possible, MS Dynamics Customer Source Support
How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server
1.      On the old server, copy the following Capture_Logins.sql script to the local hard disk. Click the following link to obtain the Capture_Logins.sql script:
2.      On the old server, run the Capture_Logins.sql script to capture all SQL Server logins and password information.
3.      Make a full backup of the DYNAMICS database and all company databases on the old server.
4.      On the old server, generate a SQL script for each SQL Server Agent Job that is currently scheduled and for each SQL Server Agent Operator that is currently set up.
5.      In Windows Explorer, copy the SQLLOGINS.sql script that you created in step 2, the backup files that you created in step 3, and the SQL Server Agent Job and SQL Server Agent Operator scripts that you created in step 4 from the old server to the hard disk on the new server.
6.      Install SQL Server on the new server if it is not already installed.
Notes Make sure that you use the same sort order that was used on the old server. To obtain the sort order that was used on the old server, run the following script against the master database in the SQL Server Management Studio, in Query Analyzer, or in the Support Administrator Console:
7.      On the new server, restore the DYNAMICS database from the backup file that you created in step 3. Follow these steps, based on the SQL Server tools that you use.
8.      Repeat step 7 for each company database.
9.      Create an Open Database Connectivity (ODBC) connection at the new server and at all client workstations that use the financial application.
10.      On the new computer, install a Server and Client installation of the financial application. Then, install any third-party products or additional products that you use on the new server. Verify that the third-party and additional products are functional.
11.      Run the SQLLOGINS.sql script that you created in step 2 to create all the SQL Server logins. You can use SQL Server Management Studio or Query Analyzer to run the script.
12.      Run the scripts that you created in step 4 to create the SQL Server Agent jobs and the SQL Server Agent Operators on the new server.
13.      Obtain the Dex_Req.sql script and the Grant.sql script, and then run the scripts.
14.      Run the following script against each financial application database to set the database owner to DYNSA.
15.      If the Reports and Forms dictionary files are shared on the old server, copy the files to the new server.
16.      If the OLE Notes files are shared on the old server, copy the files to the new server.
17.      If the Automatic Updates feature has been used and has entries that point to a share on the old server, the files must be copied to a share on the new server. The entries in the SYUPDATE table in the System DYNAMICS database needed to be adjusted.
18.      If you're moving your Microsoft Dynamics GP 2010 databases and you use the drilldown functionality in the SQL Server Reporting Services or Excel integrated reports you need to do the following to update your server links so the drilldowns work after the server move--NA
LVL 25

Author Closing Comment

by:Lionel MM
ID: 39332598
Did not get any help from anyone on this question--I had to find the answer myself.

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part III
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question