|
Great Plains Support on MSDE and SQL Express: crossing 2GB or 4GB limits
Historically Great Plains Software introduced Great Plains Select, which was available on Pervasive SQL 2000 and Ctree database platforms, not on Microsoft SQL Server. Later on, when Microsoft acquired Great Plains Software, it decided to switch from Pervasive and Ctree to newly introduced Microsoft SQL Server Desktop Edition or MSDE. MSDE, which is scaled down Microsoft SQL Server 2000 placed the limit on its database size to be 2GB. Then in 2004, Microsoft Business Solutions came out with incentive to allow Great Plains Standard 7.5 users to obtain registration key for running GP on SQL Server 2000 platform free of charge. If you are crossing 2GB DB limit on MSDN, you should consider the following actions:
1. Purge Transaction History and then rebuild database. Good idea to work on file rebuilding level. Purging transaction history, however might not be a feasible option, especially if your Great Plains users have to look up into historical data for your customers, vendors, employees, salespeople, etc. Good idea is also check the size of company DB transaction log.
2. Migrate to Microsoft SQL Server 2000 or 2005. If you are on GP version 7.5 – likely that this option is not available – you will have to obtain new reg key from Microsoft Business Solutions. If you are on Great Plains Standard 8.0, you will need to migrate to Microsoft SQL Server 2000. If you are on Dynamics GP 9.0 or 10.0 you can either migrate to SQL Server Select edition or SQL 2000 or 2005 Standard or Enterprise. Microsoft Business Solutions recommend you simply to reattach existing Dynamics and company databases files to newly installed SQL Server
3. If you do not have support contract with Microsoft and not sure who is your existing Great Plains VAR. All written above is definitely cool for those who are current in Dynamics GP annual enhancement program, which allows you to have access to your Customer Source, where you can get your new Great Plains version reg key. If you lapsed in annual enhancement, you will have to select Great Plains Reseller or consultant, sign Change VAR form to your new GP Partner, and then your new VAR will have access to your historical Great Plains Registration Keys
4. From MSDE 2000 to SQL Express 2005. In SQL Express you have 4GB DB limit, which is good postponing option, however please know that you will need to upgrade to at least Great Plains Dynamics GP 9.0. Last warning. If you are subscriber to MSDN or Microsoft TechNet – you may have access to all Dynamics GP versions CD images, however these subscriptions are for evaluation only – do not use these CDs for upgrade purpose, if you do not have reg key for targeted version of Dynamics GP
We specialize in GP system recovery. Serving GP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP 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, Central America
Company: Alba Spectrum
|
| Related press releases |
Great Plains Support on MSDE and SQL Express: crossing 2GB or 4GB limits [2008-12-21 14:13:31]
Historically Great Plains Software introduced Great Plains Select, which was available on Pervasive SQL 2000 and Ctree database platforms, not on Microsoft SQL Server. Later on, when Microsoft acquir...
|
|
Cibersql Releases SQL Web Admin 2.0, a web-based and Ajax-based MSDE and SQL Ser... [2007-09-25 01:15:47]
Cibersql Releases SQL Web Admin 2.0, a web-based and Ajax-based MSDE/SQL Server 2005 manager. Web Admin 2.0 allows users to easily create and edit databases, tables, views, stored procedures, users, ...
|
|
VoEx Extends Its Revolutionary VoIP Solutions to the Enterprise Market Using Glo... [2004-09-18 00:00:00]
VoEx to deliver its high-quality enhanced voice applications to large enterprise clients utilizing Global Crossing's suite of wholesale voice, data and IP services.
January 15, 2004--Global Crossing ...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
New VistaDB 2.1 release supports Visual Studio .NET 2005 [2005-10-25 00:00:00]
LA JOLLA, Calif. Oct 24th, 2005 Vista Software today announced a significant free 2.1 update to their widely used VistaDB embedded SQL database engine for Microsoft .NET. With this release, the co...
|
|
Great Plains Reports Design: Crystal, SRS, MS Access, Excel, ReportWriter, Dexte... [2008-06-22 16:19:02]
Microsoft Dynamics GP is successor of former Great Plains Dynamics and eEnterprise, current GP version is 10.0. Since the time when GP became exclusively available on MS SQL Server DB platform only (...
|
|
Great Plains Version Upgrade Microsoft Dynamics GP installation notes Alba Spe... [2007-10-07 03:20:00]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be str...
|
|
Cibersql, LLC Releases High Performance Web-based SQL Server Reporting Solution [2005-04-27 00:00:00]
Cibersql, LLC Released Cibersql Web Report, a sophisticated yet easy to use reporting web application built specifically for SQL Server and MSDE databases.
Its unique capabilities enable users to cre...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
OE-Mail Recovery [2004-11-30 00:00:00]
Outlook Express Recovery (Repair Outlook Express) tool
OE-Mail Recovery is a tool for repairing Outlook Express folders if they are damaged or corrupted. OE-Mail Recovery extracts and saves e-mails fr...
|
|
|
|
| MP3Producer |
 MP3Producer is a powerful full-featured CD ripper and MP3,WMA,OGG encoder. ID3v1,2 tag; FreeDB(CDDB) support; Extract CD Segment function; multilingual interface; MPEG1,MPEG2; constant, variable, average bitrates (8-320 kbps); flexible settings. |
|
| Screen Paver |
 Screen Paver is an easy to use make-your-own slide show screen saver. The program will display an unlimited number of your own jpeg, png, or bitmap images from local and/or network directories. Plays music too. Great for digital camera users. |
|
| Amazon Price Watch |
 Amazon Price Watch help you to keep track of the price, get notice when hot item is available or price drops for your wishlist, and find great deals or filler items when you need a bit more for free shipping. |
|
| GetMail |
| Do you want to read webmail only mail systems such as Hotmail, MSN, Windows Live Mail, AOL, Yahoo on your mobile device such as a Blackberry. GetMail will help by forwarding your email to a standard POP3 account that most mobile devices support. |
|
| VideoDesktop Dream Scape |
 Dream Scape Video Desktop uses very few of the computers resources. Hotkey support and snap shot tool with zoom preview. Get a fun, amazing and different desktop manager today and place your favorite video clips on your desktop! |
|
| CRM-Express Professional |
 CRM Software - CRM-Express Professional is the latest in CRM (Customer Relationship Management) software. CRM-Express can manage your marketing, customers, sales and orders. Features include SMS abilities, Email Client, Calendar, Address Book |
|
| Sitemap Writer Pro |
 Professional XML sitemap generator will help you easily create XML sitemaps. Automatically generate sitemaps in XML or compressed gzip format, keep up-to-date, edit them, upload to web server and submit to search engines that support XML sitemaps. |
|
|
Latest press releases
