Note Unc

Microsoft Great Plains 7.5 on Pervasive SQL Migration to Windows 2008 Server Notes

We would like to share with potential customers or Microsoft Dynamics GP consultants our successful redeployment of old Great Plains Dynamics on new Microsoft Windows 2008 Server 2008.  This opens good strata of possibilities for old versions Great Plains and Dynamics GP customers on Pervasive SQL 2000 to move from Windows 2000 or Windows NT Server to Windows 2008 or Windows 2003 Server and redeploy Great Plains user workstations on Windows XP or Vista.  There is always a possibility to upgrade to newest Dynamics GP version 10.0, which requires migration from Pervasive SQL to Microsoft SQL Server 2000 for Great Plains 7.0, however we understand that if you decided to stay with old version, this decision probably was based on the lack of budget to pay Great Plains annual enhancement program

1. Migration Scenario.  We had Pervasive SQL Server 2000 SP2 running on Windows XP workstation (deployed as Great Plains Server).  Great Plains User workstations were on Windows 95 (this is in our opinion the same as if they would have poor hardware with Windows 97, Windows 2000, or even first releases of Windows XP).  Target was to move them to Windows 2008 Server (please, do not expect too much miracles, it should be 32 bit edition, it is unlikely that you could install Pervasive SQL 2000 SP 3 maximum on 64 bit platform, if you find out how to do this – let us know and we will ship you small pocket aquarium).  FRx was not deployed in this environment, but we know that old FRx Sysdata folder is not supported on Windows 64 bit platform

2. Great Plains Server Side Installation.  Load Pervasive SQL 2003 Service Pack 3 (we recommend this service pack, as you do not have to alter Pervasive Engine Settings, for older SPs you need to check with GP techknowledge on the Settings required changes).  Open Port 3351 on Windows 2008 Firewall – as you may know Windows 2008 Server blocks all the ports, except the ones used by required services (Pervasive SQL 2000 is definitely not one of those).  Copy Great Plains Database Folder (typically named Dynamics from old server to the new one) and share this folder.  In security for this shared folder add Domain Users to have Full Control (this is required by Pervasive SQL 2000 data access, adding and modification model)

3. Great Plains Client Installation.  Please, insert Great Plains CD#1 (if you have additional modules such as Fixed Assets, Manufacturing, Human Resources, there is no need to install them as we will copy their libraries from old Great Plains Workstation, see our notes below) and follow the steps to install Multiuser workstation.  Use the same path as you had it for legacy installation, usually C:Dynamics.  When user workstation installation is done, rename C:Dynamics folder to C:OldDynamics.  Then copy old Dynamics GP workstation to your new user workstation computer to the same folder, in our case C:Dynamics.  If you have third party add-ons, such as Wenn Soft  Field Service, please read Great Plains ISV add-on documentation.  In the case of Wenn Soft we were able to enable it by registering WS*.dll, simply copy them from your GP workstation to System32 folder on each user workstation and register them via REGSVR32 command.  If you do not do this you will get error message on Great Plains login and Wenn Soft card login: Decrypt Service Failed to Start.  If your old Pervasive SQL based Great Plains system was on UNC Path, you will need location translation service or help

4. Intellisol.  This add-on was not present in our tested migration, however we believe that Intellisol Advance Purchase Order Processing or Project Accounting would require similar approach

5. Great Plains Accounting For DOS and Windows 9.5, 9.2, 9.1 or earlier versions.  Yes, you got it – if you still have this legacy Corporate ERP in production, we support it.  We support GPA for local customers in Chicagoland, or if you are in USA and Canada we support it via web session and other remote support technologies.   We tried and got success in GPA for DOS and Windows redeployment on Windows 2003 Server Release 2, where GPA workstations were on Windows XP Professional

6. Old Dynamics version upgrade path.  In case if you decide that it is now time to invest in Corporate ERP system re-haul and upgrade, what we need from you is to sign Dynamics GP Switch VAR form to Alba Spectrum .  Then we will be your broker for Microsoft Business Solutions, and we should be able to add new company in the case if you are on Great Plains Accounting for DOS or Windows and give you its registration key.  If you are on Great Plains Dynamics 6.0, 5.5. 5.0, 4.0, 3.2 or earlier your upgrade path should be reviewed.  Simply call us and have us to see via remote connection or web session you current Great Plains Workstation

7. We certainly understand your concerns that Great Plains Dynamics and eEnterprise were targeted to mid-market businesses, and their redeployment is not apparent.  If you feel that budget is tight, try to make as much homework as you could and then feel free to call our office for urgent help

8. How to get help?  Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us help@albaspectrum.com  We are very technical and real Dynamics GP Dexterity, SAP Business One SDK programming gurus.  We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs.  Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants.  If you prefer skype: albaspectrum

About the Author

Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America: Honduras, Costa Rica, San Salvador, Panama, Nicaragua, Guatemala

The Greatest UNC Basketball Moments of All Time

1 CENTAVO Note NICARAGUA 1991 – CORDOBA Portrait – UNC $0.00

“UNC-CU” Series 1929 American Bank Note Company “Specimen” 10 Denomination $0.00

Bangladesh 20 Taka 2011 P-48 Mint UNC Uncirculated Notes $0.00

South Vietnam 500 Dong 1972 P-33 Mint Crisp UNC Uncirculated $0.00

Uganda 2000 shillings 2010 P-50 Mint UNC Uncirculated Banknotes $0.00

Nepal 20 Rupees 2008 P-62 Mint UNC Uncirculated Banknotes $0.00

Nepal 5+10+20 Rupees 2008 Set 3 pcs Mint UNC Uncirculated Banknotes $0.00

Congo 50 Francs 4.1.2000 P.91a Printer HDM Mint UNC $0.00

Burundi 2005 50 Francs P.36e Mint Uncirculated Notes UNC $0.00

Ecuador 5 Sucres 1982 P-108b Mint UNC Banknotes $0.00

Guinea 2010 1,000 / 1000 Francs P-New Crisp Uncirculated UNC $0.00

Ecuador 5 Sucres 1988 P-113d Mint UNC Banknotes $0.00

Ecuador 10 Sucres 1988 P-121 Mint UNC Banknotes $0.00

Ecuador 20 Sucres 1980 P-115b Mint UNC Banknotes $0.00

Ecuador 20 Sucres 1988 P-121Aa Mint UNC Banknotes $0.00

Ecuador 50 Sucres 1982 P-116e Mint UNC Banknotes $0.00

Australia 2008 $20 polymer banknote, UNC $0.00

Ecuador 100 Sucres 1988 P-123Aa Mint UNC Banknotes $0.00

UK Bank of England 2000, 10 Pound banknote in mint UNC, current $0.00

B321 PAGE £1 REPLACEMENT ERROR NOTE * SLIP & STICK * PAIR * UNC * LOT 2 * $0.00

Pair of Central Bank of Ireland £1 and £5 Banknotes – Perfect UNC. $0.00

1952 – White Bank of England £5 Note * UNC * $0.00

North Korea 10 Won 1998 SPECIMEN NOTE P41 @ UNC $0.00

Jamaica $50 2010 P-New Mint Uncirculated Notes UNC $0.00

1968 – Central Bank of Ireland, Lady Lavery 10 Shillings *UNC* $0.00

1972 South Vietnam (Viet Nam) 500 Dong Bank Note Tiger P 33 UNC $0.00

1962 – Central Bank of Ireland, Lady Lavery £1 *UNC* $0.00

MEXICO 2 CONSECUTIVE NOTES 2 X 20 PESOS P-NEW 2008 POLYMER UNC $0.00

MEXICO 2 CONSECUTIVE NOTES 2 X 20 PESOS P-NEW 2008 POLYMER UNC SERIE ” H ” $0.00

Thomas De La Rue, Advertising / Promotional note, 50 core, 2001, TDLR, UNC $0.00

100 TRILLION ZIMBABWE DOLLARS + 10000 PERU INTIS BANK NOTE UNC $0.00

AUSTRALIAN BANKNOTE $1 DOLLAR 1982 P42 UNC $0.00

AUSTRALIAN BANKNOTE $2 DOLLARS 1985 P43 UNC $0.00

1993 Croatia 50000 Dinara Bank Note P 26 UNC $0.00

ANTARCTICA BANKNOTE 2 DOLLARS 2008 UNC $0.00

PARAGUAY BANKNOTE 1,000 GUARANIES 2005 P222 UNC $0.00

1993 Croatia 100000 Dinara Bank Note P 27 UNC $0.00

BURUNDI BANKNOTE 10 FRANCS 2005 P33 UNC $0.00

BURUNDI BANKNOTE 50 FRANCS 2006 P36 UNC $0.00

BURUNDI BANKNOTE 100 FRANCS 2006 P37 UNC $0.00

BURUNDI BANKNOTE 1,000 FRANCS 2006 P39 UNC $0.00

1863 $1 Northampton, MA Obsolete Note, BEAUTIFUL UNC! $0.00

YEMEN BANKNOTE 250 RIALS 2009 PNEW UNC $0.00

CHINA BANKNOTE 2 JIAO 1980 P882 UNC $0.00

2007 $10 AA07 First Prefix ( RARE REPEATER SERIALS ),Banknote in unc Condition $0.00

CHINA BANKNOTE 1 YUAN 1999 P895 UNC $0.00

CHINA BANKNOTE 5 YUAN 2005 P897 UNC $0.00

SOUTH KOREA BANKNOTE 1,000 WON 2007 P54 UNC $0.00

HONDURAS BANKNOTE 1 LEMPIRA 2004 P84 UNC $0.00

TANZANIA BANKNOTE 500 SHILLING 2003 P35 UNC $0.00