Best way to test

[cryrep]

I would like to set up a test Compagny. We upgrade from GP8 to Dynamics 9, and i would like to know the easy way to proced, i install SQL 2005 and Dynamic 9 already

What should i do to transfer all the compagny database to the new 2005 server.

i did find in MS document the prodcedure for a case like mine

Could someone Help me with this

 

[DBan13]

I just created a test box to test our upgrade to version 9, but I did it a little differently. This is what I did that worked very well. I wanted to create an exact replica of our live version 8 box to do a true test of the upgrade.

1. Installed SQL server 2000 with the same exact specs as live server
2. Transferred the GP databases following the detailed instructions in Knowledge base article 878449 (How to transfer an existing MS …..)
3. Installed GP v8 and all 3rd party products
4. Followed all of the preparation steps recommended in the MS – Microsoft Dynamics GP Upgrade instructions.
5. After completing Part 1 of the upgrade instructions, Preparation, I backed up the databases on the test server. That way, if I needed to run through the upgrade again, I would not have to run through the preparation piece again, just restore these databases. I also exported all of my modified forms and reports. It did not say this in the instructions, but I also found that everything ran smoother if I deleted all of the current logins. (Tools -> Setup -> User Activity).
6. I then ran through the upgrade process as outlined in the document.

I received errors on 2 of my 7 companies on the first try. I was able to restore the tables I had backed up and run the upgrade again. I documented everything I did to resolve the errors and then would run the upgrade again. On the 3rd try it went perfectly. I now have documented the changes I need to make to the live server to ensure that the upgrade goes smoothly. I did not upgrade to SQL 2005, but all of the Microsoft documentation I have read, recommends you upgrade to GP 9 and then upgrade to SQL 2005.

Hope this helps.

 

[cryrep]

Thank you for you help i will do like this, and do a folow up with the result on sql 2005

 

[jymm]

and I went the other way around --- I upgraded to SQL 2005 THEN one weekend then to Dynamics 9 the following weekend. In between I restored all of the dynamics dbs to my development box and did the upgrade there (then had users come in to see the changes).

With the exceptions of some security for the lists not copying over (so the manufactuiring facility temporaily had access to Payroll lists) and the fact that we have a shared dictionary for custom reports (and those never have converted right with my GP upgrades anyway) --- EVERYTHING went VERY smoothly --- compared to going from SQL 7 to 2000 or going from GP 6 to 7, 7.5 or 8 --- this was the shortest upgrade time AND the easiest (but do not tell my boss that).