Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software ? the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence ? via it's C-written engine Dexterity, based on the believe that C programming language is platform independent. So ? Great Plains was running on MS SQL Server, Ctree (Faircom ? if you remember 1995-96 Macintosh era), Pervasive SQL (Btrieve). Microsoft obviously had no plan to keep this multiplatform capability and Great Plains was optimized to MS SQL Server and with the introduction of MSDE ? the need to keep entry level Dynamics on Ctree/Btrieve disappeared.

Microsoft Great Plains Business Solutions, later renamed to Microsoft Business Solutions was sending multiple signals to Dynamics customers to migrate to SQL Server, later on to upgrade to Great Plains Standard on MSDE. Recently it promoted all the clients who own Great Plains on Ctree/Pervasive ? so now they technically own so called Great Plains Standard. All they need to do is pay for Migration (around k$3 + consulting fee to whoever your MBS VAR is).

Unfortunately MBS did several rough turns in the process of this migration from ctree/Pervasive to SQL/MSDE.

Until early 2004 you could see support expiration date for Great Plains 7.5 on Ctree/Pervasive was July, 31, 2005. In about April, 2004 ? Microsoft roughly changed it to December 31, 2004. This actually exposed all the clients with regulation-related modules (such as US Payroll ? where you rather do not risk with printing W2s without support) to serious problems

Clients who migrated to Great Plains standard are now in the feeling that they paid for something that is free now. See above ? all the low price GP clientele now technically owns GP Standard

Ctree/Pervasive clients with high volume of employees count in GP Payroll/HR now have to cut it to 500 employees due to the cap for GP Standard. You can imagine frustration, especially due to the fact that a lot of mid-size and big companies were running very cheap Dynamics on Ctree for just Payroll/W2 filing. This was a very nice alternative to products like Abra HR ? not any more.

What to do. Well, if you plan to stay with GP ? the only alternative is to migrate to MSDE. Contact your MBS VAR (or call us directly: 1-866-528-0577). You will be given Migration Tool quote ? then install MSDE and Great Plains with exactly the same accounts structure that you have on Pervasive/Ctree. Tune Migration Tool, select all the tables in all the modules, click the button and wait a few hour ? and you are in the SQL World!

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Illinois, California, Texas, Florida, New York, Georgia, Colorado, Minnesota, Washington and having locations in multiple states and internationally www.albaspectrum.com, he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: [email protected]

[email protected]

In The News:

Wipro's non-software businesses are ready for their moment in the sun  Economic TimesThe disparate, unglamorous businesses Premji had demerged seven years ago are now on the verge of surprising the business world.
OpenAI refuses to release software because it's too dangerous  Fast CompanyAI researchers fed their piece of software the first sentence to George Orwell's 1984, and it produced the following text: advertisement. I was in my car on my way ...
Oppo K1 review: Excellent design but camera, software need work  Hindustan TimesOppo K1 is available in India for a starting price of Rs 16990. The smartphone comes with up to 6GB of RAM, 25-megapixel selfie camera, and 3600mAh battery.
NIOSH releases new EXAMiner training software  Mining TechnologyNIOSH has released a beta version of its new EXAMiner training software, which is designed to help miners improve their ability to identify hazards.
Software pirates use Apple tech to put hacked apps on iPhones  ETTelecom.comSAN FRANCISCO: Software pirates have hijacked technology designed by Apple Inc to distribute hacked versions of Spotify, Angry Birds, Pokemon Go, ...
Batch edit Photos using these free software for Windows 10  TWCN Tech NewsBatch edit Photos using these free software for Windows 10. These free Batch Photo Editors allow users to make changes accross several photographs ...
BASIS software expo begins March 19  The Daily StarA three-day BASIS SoftExpo 2019 will begin on March 19 with the slogan “technology for prosperity” and promises to be the country's largest exposition of ...
Patch software to improve police efficiency | News, Sports, Jobs - The Review  The ReviewLISBON — County commissioners are helping the sheriff's office and other local departments get the software necessary to allow them to communicate informati.
Novel software offers possible reduction in arrhythmic heart disease  Science DailyPotentially lethal heart conditions may become easier to spot and may lead to improvements in prevention and treatment thanks to innovative new software that ...
How to make PDFs in macOS Mojave without any extra software  AppleInsiderYou've been able to make a PDF out of any document on Macs for years. We take it so much for granted, though, that we don't know what extra options we've ...
Software Epigenetics and Architectures of Life - e-flux Architecture  E-FluxAn End User Undertaking (EUU) is an agreement proffered by software manufacturers and signed by the representatives of software consumers that codifies a ...
NVIDIA Dominates The Steam Hardware & Software Survey, Yet Again  TechQuilaEvery month Steam releases its survey listing the hardware and software used by its users, and NVIDIA is still the most popular GPU brand.
Software error caused 7700 Singaporeans to receive inaccurate CHAS subsidies, says Singapore's Health Ministry  Healthcare IT NewsDue to an error in the software administered by NCS Pte Ltd (NCS), about 7700 individuals received inaccurate healthcare and intermediate and long term ...
The New PCI Software Security Framework -- What You Need To Know Now  ForbesThe Payment Card Industry Security Standards Council just launched the PCI Software Security Framework targeting application security. After over a year of ...
RISC-V Climbs Software Mountain  EE TimesSAN JOSE, Calif. — Now that RISC-V has established a beachhead as a deeply embedded controller in SoCs, it's time to start asking the next question: Can this ...
Budget software, legislative bills topics during council retreat  Grand Island IndependentBetter utilization of a tool for the public to view financial data was just one topic discussed at a day-long Grand Island City Council retreat.
Ottawa security firm Interset bought by U.K. software giant  Ottawa CitizenAn Ottawa security and data analytics firm has been bought by a massive U.K. software company for an undisclosed amount.
Top 4 software to recover lost email account passwords  Windows ReportLost or forgotten your email account password for Gmail, Yahoo, Live Mail, Outlook, Thunderbird etc? Here are the best software to recover forgotten it.
Insurance software firm Ebix buys majority stake in travel tech platform Zillious  VCCircleNasdaq-listed insurance software firm Ebix Inc. has acquired 80% stake in travel technology company Zillious Solutions Pvt. Ltd.
Tera Software Standalone December 2018 Net Sales at Rs 19.97 crore, down 43.12% Y-o-Y  Moneycontrol.comNet Sales at Rs 19.97 crore in December 2018 down 43.12% from Rs. 35.10 crore in December 2017. Quarterly Net Profit at Rs. 0.38 crore in December 2018 ...
Crossover: A software sweatshop  Forbes IndiaTwo decades ago, Joe Liemandt became the youngest member of the Forbes 400 by building an enterprise software juggernaut. He's quietly returned, bigger ...
Pinpoint raises $13.5 million to bring data analytics to software development  VentureBeatAustin-based startup Pinpoint seeks to bring transparency to sofware development with an innovative data analytics platform.
Israeli software firm DriveNets raises $110 million in first funding round  ReutersTEL AVIV (Reuters) - Israeli networking software company DriveNets said on Thursday it raised $110 million in its first round of financing led by Bessemer ...
What Will Software Look Like Once Anyone Can Create It?  HBR.org DailyA former YouTube executive on building apps without knowing how to code.
The Internet Was Built on the Free Labor of Open Source Developers. Is That Sustainable?  MotherboardA look at the complicated business of funding open source software development.
How to update the software on your Honor 8X  Android CentralUpdates bring new features, tighten up security, and generally make us feel good. Make sure you never miss one on your Honor 8X by learning how to update it.
Astronomy club to unveil sky-watching software at SUNY New Paltz  Times Herald-RecordNEW PALTZ — On Tuesday the Mid-Hudson Astronomical Association will conduct a workshop on the use of the free software Stellarium.Stellarium allows the ...
3 Software Stocks to Buy for Big Changes And High Growth  Investorplace.com[Editor's note: This story was previously published in MONTH YEAR. It has since been updated and republished.] The search for software stocks to buy provides ...
Move Over Actors And Artists, Software Developers Are True Creative Heroes  ForbesSoftware engineers are not workhorses, they are inherently creative people who, given the right environment, can transform the fortunes of a company. Business ...
ADTRAN Unveils New Software-Only Solution to Help CAF Service Providers Comply and Manage Performance Testing  Business WireCloud-based, open system works without extra equipment or raising privacy concerns—delivering enhanced user experience.
InfluxData raises $60 million for time-series database software  VentureBeatInfluxData has raised $60 million for InfluxDB, its time-series data management software that's freely available on GitHub.
Commonwealth Financial, MassMutual strike software deal  InvestmentNewsMassMutual will license Commonwealth's proprietary adviser software, Advisor360.
Anti-violence measures including phone checks for hidden software  The AdvertiserPeople who fear they are being cyber-stalked by a controlling partner would be able to scan their mobile devices for hidden software under a trial to ensure the ...
CBSE Board Exam 2019: Board to use TETRA software to balance difficulty level  India TodayCBSE will use TETRA software to level playing field and avoid paper leaks.
Encourage Your Team To Install Software Updates With These 10 Tactics  ForbesMembers of Forbes Technology Council offer practical ways for tech officers to get their companywide team to proactively update software for security and ...
Pembroke Management LTD Cuts Position in Upland Software Inc (UPLD)  Fairfield CurrentPembroke Management LTD decreased its holdings in Upland Software Inc (NASDAQ:UPLD) by 4.2% in the 4th quarter, according to the company in its most ...
Samsung One UI (Android 9 Pie) review: Samsung's best software yet  Android CentralSamsung's Android 9 Pie release, with the new One UI interface and features, is something every Samsung phone owner should look forward to.
Making the Grade: iTunes U and iBooks Author are suffering from software rot  9to5MacApple has a software rot problem with two of its K-12 focused applications. iTunes U and iBooks Author seem to be on life support with no end in site.
Finding the Value in Anaplan vs. Adaptive Insights Software  Business News LedgerThe marketplace for software programs assisting the business community is diverse and evolving to a scenario where competition is increasing exponentially.
Software developers need more confidence on Stack Overflow  QuartzEvery software developer is familiar with the site Stack Overflow, the 11-year-strong compendium of questions and answers. Part knowledge base, part social ...
Artificial Intelligence Software Created to Treat Ovarian Cancer as Death Toll Due to Disease Likely to Incre  India.com NewsWith the incidence of ovarian cancer likely to increase by 55 per cent in another 15 years or so, researchers have created an artificial intelligence (AI) software to ...
The Register's old press room has been converted into a software company's office  Des Moines RegisterA software company that manages electronic records for fire departments nationwide has opened an office in the Des Moines Register's old press room.
Software failed to send mail to new UM students for 2 years  NBC MontanaAfter over two years of software glitches at the University of Montana, officials claim the system is now working properly. A software program that was designed to ...
Why Software Companies Should Care About Global Warming  ForbesGlobal warming could affect every industry and area of the planet. Many tech giants are working toward greater energy efficiency and sustainability -- and your ...
Parkland school turns to surveillance software that can flag students as threats  NOLA.comKimberly Krawczyk says she would do anything to keep her students safe. A year ago Thursday, the Parkland high-school math teacher barricaded students ...
Warburg Research Analysts Give Software (SOW) a €50.00 Price Target  Fairfield CurrentWarburg Research set a €50.00 ($58.14) price objective on Software (ETR:SOW) in a report released on Wednesday, January 23rd. The firm currently has a buy ...
Software Testing Tool Market – Major Technology Giants in Buzz Again : Ranorex Studio, UserTesting, Sauce Labs, TestRail - Press Release  Digital JournalIf you are involved in the Global Software Testing Tool industry or aim to be, then this study will provide you inclusive point of view. It's vital you keep your market ...
Ultimate Software to Go Private in $11 Billion Cash Deal  BloombergQuint(Bloomberg) -- Ultimate Software Group said it agreed to be acquired by an investor group led by Hellman & Friedman Capital Partners in a deal valued at about ...
Progress Software Corp (PRGS) Position Decreased by Cigna Investments Inc. New  Fairfield CurrentCigna Investments Inc. New cut its holdings in shares of Progress Software Corp (NASDAQ:PRGS) by 38.2% during the fourth quarter, according to its most ...
Aurora Solar Raises $20 Million Series A to Scale Solar Software  Greentech Media NewsAurora Solar has raised a $20 million Series A to fund its quest to become the premier solar software provider.
Atlassian rewrites the SaaS playbook with beloved products like Jira  Business InsiderAtlassian is so vital to how businesses work, it's practically recession-proof, says BTIG's Joel Fishbein.
Belize-born software pioneer shares inspiration with US students  Breaking Belize NewsPosted: Tuesday, February 12,2019. 1:50 p.m. CST. By BBN Staff: A Belizean-born software engineer is using his story to encourage students at a school in ...
Software Engineer Loses Life Savings in Quadriga Imbroglio  BloombergTong Zou wasn't a stereotypical crypto bro bent on accumulating flashy trophies such as Lamborghinis when he deposited his life savings into Quadriga CX's ...
Sony Pictures Has Open-Sourced Software Used to Make ‘Into the Spider-Verse’  VarietySony Pictures Imageworks has contributed a software tool used to create movies like “Spider-Man: Into the Spider-Verse,” “Hotel Transylvania 3,” “Alice in ...
How Salesforce's Marc Benioff Revolutionized The Software Industry  Investor's Business DailySalesforce CEO Marc Benioff is the father of cloud computing. His ability to predict trends and his focus on trust and basic values are keys to his success.
The Best Online Tax Filing Software for 2019  TheStreetThe 2019 online tax preparation packages are out, and there is no shortage of great tax management deals to choose from....HRB.
If Software Is Funded from a Public Source, Its Code Should Be Open Source  Linux JournalIf we pay for it, we should be able to use it. Perhaps because many free software coders have been outsiders and rebels, less attention is paid to the use of open ...
Why free software evangelist Richard Stallman is haunted by Stalin's dream  FactorDailyMore than 30 years ago, Richard Stallman quit a doctorate program at the MIT to start the GNU Project, a free software operating system. Not only has he been ...
Bill and Melinda Gates said software is making school textbooks obsolete, and it could save college students thousands of dollars  Business InsiderNot only is technology making physical textbooks "a thing of the past," Bill and Melinda Gates wrote, but it's making education cheaper, too.
Cities Are Secretly Testing Predictive Policing Software  VICEAccording to documents obtained by Motherboard, the use of the predictive policing software PredPol is far more widespread than previously reported.
11 Best Free Floor Plan Software Tools in 2019  G2 CrowdFloor plan software has myriad uses, including office space planning, facility plant floor planning, and venue management planning. Even parking lots benefit ...
Stupid Patent of the Month: IBM's Software Patent on Texting and Driving  EFFIn the smartphone era, “distracted driving” is a serious, and well-known, problem. Official warnings about poor driving habits are as old as the automobile itself.
Who is in Charge of Quality in Software Development  InfoQ.comAs silos break down, the whole team is responsible for quality in software development. As process more and more defines people and processes, how can you ...
AMD Radeon VII To Get Radeon Pro Software For Enterprise Support Soon, Also Receives BIOS Update To Support UEFI  WccftechAMD's recently released Radeon VII graphics card will soon be getting support in the Radeon Pro software stack, making full use of its compute prowess.
Tesla hides extensive ‘Back to the Future’ Easter egg in latest software  ElectrekTesla has carefully hidden an extensive 'Back to the Future' Easter egg in its mobile app software and it was discovered this week.
Help Health Canada to Regulate Software as Medical Devices (SaMD) |  MedgadgetHealth Canada has written a guide for regulating software as medical devices (SaMD). They are now asking for input on their regulations by healthcare.
Event Management Software Market – Share Expected Huge Growth During 2016–2024  Industry News NetworkZion Market Research Offers an 8-Year Forecast In 110+ Pages Research Report “Event Management Software Market: Global Industry Analysis, Size, Share, ...
Apple releases FaceTime software fix for eavesdropping flaw  BNNBloomberg.caApple Inc. (AAPL.TO) on Thursday released a software update for iPhones and its other devices to fix a bug that let users of its FaceTime video-chat *service* ...
How This Company Created the First Software Development Apprenticeship Program Approved by the Department of Labor  Inc.I talked with Heather Terenzio of Techtonic about the company's unique recruiting and training program, and its impact on talent and diversity.
KKR KKR strikes billion-dollar software deal with OneStream February 7, 2019 KKR has agreed to  PitchBook News & AnalysisKKR has agreed to back OneStream Software at a valuation of more than $1 billion, with The Wall Street Journal reporting the firm will shell out over $500 million ...
Looking to give wings to your software development and deployment?  The RegisterEvents Whether you're just piloting your first DevOps projects, want to scale things up, or are ready to leap into Kubernetes or Serverless, you should be joining ...
Designing Convergent HPC and Big Data Software Stacks: An Overview of the HiBD Project  insideHPCIn this video from the 2019 Stanford HPC Conference, DK Panda from Ohio State University presents: Designing Convergent HPC and Big Data Software ...
Chasing Software Revenues  Crunchbase NewsMorning Markets: WeWork snags another software company. Why? Follow Crunchbase News on Twitter · WeWork, recently renamed as “We,” has bought ...
Cisco’s AppDynamics software ties in SDN, serverless for greater app management  Network WorldThe wide-ranging Cisco AppDynamics announcement targets enterprise customers looking to monitor performance and automate the response to problems in ...
Magic Software Enterprises Ltd (MGIC) Expected to Announce Quarterly Sales of $73.75 Million  Fairfield CurrentBrokerages expect that Magic Software Enterprises Ltd (NASDAQ:MGIC) will announce sales of $73.75 million for the current fiscal quarter, Zacks Investment ...
John Deere Updates Gen 4 Software and Machine Sync  Agriculture.comWith the release of its 19-1 software, the automation, documentation, functionality, and security of John Deere's Generation 4 4600 CommandCenter and 4640 ...
New Frontiers In Software Testing: Exciting Trends To Expect In 2019  ForbesThe evolution in software testing has entered a new stage whose legacy we are yet to experience and benefit from in full. This year will see a continuation of this ...
Franklin software company shares plans to expand in Williamson  The TennesseanQuore announced it will expand its Franklin operations for its hotel management software business.
Cisco patches serious SD-WAN software security holes  Network WorldCisco has patched security vulnerabilities in four packages of SD-WAN Solution software that address buffer overflow and other vulnerabilities.
More On The Return Of Tesla’s Software-Limited Battery Pack Scheme  InsideEVsWe really can't say we're surprised to see the return of Tesla's software-limited battery scheme. It just makes more sense to handle "trims" this way.
PhotoPad is a free Photo Editor software for Windows PC  TWCN Tech NewsPhotoPad is an easy-to-use, comprehensive photo editors for Windows PC that offers picture enhancing tools for beginners & advanced tools for professionals.
SolarWinds CEO On MSP Software, Private Equity And DRaaS  ChannelE2ESolarWinds CEO Kevin Thompson's favorite acronym appears to be MSP (managed services provider). The evidence: Thompson, his executive team, and Wall ...
Rosegreen's Denise Manton for top job with Lero, the Irish Software Research Centre  TipperaryLive.ieDenise Manton from Rosegreen near Cashel, has been appointed business development and commercialisation manager of Lero, the Irish Software Research ...
How Software Outsourcing Can Empower Digital Transformation  DevOps.comSoftware outsourcing businesses often adapt better to the evolving digital landscape because they aren't afraid to look outside an organization.
Tableau Execs Talk About New Software, Battling Microsoft, M&A and More  TheStreet.comCFO Damon Fletcher and product chief Francois Ajenstat see new features helping Tableau's analytics software win over more rank-and-file office workers.
13 Best Construction Project Management Software Solutions in 2019  G2 CrowdIf you're curious how to choose the best construction project management software, fortunately, G2 Crowd has a trove of information on just that.

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

String in Java

Handling character strings in Java is supported through two final... Read More

DVD Burning Tips

CD and DVD replication is a process that works by... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More

Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Microsoft Small Business Manager eCommerce ? Overview

Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

Logistics automation is often considered as barcoding extension to Sales... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

The Software 2005 Conference - A Review

The Software 2005 conference is now a wrap. This conference,... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

FreeDOS

Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Introduction To ISDN, Part III: PAP

Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More

Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

In the case when you represent mid-size or mid-size-to-large business,... Read More