| |
| |
|
Software Information |
|
|
|
Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair - Overview For DBAs
Some introduction into Great Plains Software products, now Microsoft Business Solutions. Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology - Great Plains Dexterity dictionary DYNAMICS.DIC and runtime DYNAMICS.EXE), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. If you are database administrator who is supporting the version on Pervasive SQL.2000/Ctree - read this and you will have the clues on where to look further. 1. Microsoft Great Plains Tables Structure - Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers - it should be RM00101 - customer master file, account master file - GL00101, Sales Header Work file - SOP10200 - and you got the idea. 2. Use Microsoft Access. Lunch Microsoft Access and make a link to Microsoft Great Plains tables. This will allow you to do data modification/repair. Some people are trying to use Pervasive control center - we do not recommend this - MS Access does job better. 3. Locked batch repair - unlocking the batch, which was interrupted in posting. The tables: SYoo500 - batch header - you need to change Batch Status or Marked for Posting field 4. Activity table - If you have user locked in Great Plains - just ask all the other users exit and delete ACTIVITY.BTR (Pervasive) or ACTIVITY.DAT (Ctree) 5. Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. This will allow you to deploy ODBC connection to Great Plains database 6. Sometimes you have to rescue to Great Plains Dexterity- when you need ongoing data import and you do not own Great Plains Integration manager or when Integration Manager doesn't have the object to deploy. This is proprietary Great Plains Software tool and development environment and you need some time invested, before you can do programming. 7. Complex Data Migration - use MS SQL Linked Server - you can create linked server to Pervasive/ctree and then you can create the cursor, coming through all the tables in your migration set - we usually recommend reading tables schema in MS SQL Server (it is the same to Pervasive) and pull the data from Pervasive database using EXEC statement in Transact SQL. Happy data repairing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, San Francisco, Los Angeles, San Diego, New York, Boston, Atlanta, Houston, Austin, Dallas, Miami, Atlanta, Denver, Phoenix, Minneapolis, Canada, UK, Australia, Europe, Moscow and having locations in multiple US states (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, MS Access, Crystal Reports and Microsoft CRM SDK developer.
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
Microsoft Great Plains Data Conversion - Overview For Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Review on QuarkXpress 6.0 After almost two decades of existence, Quark has become the basic building block of any print designer's toolkit. It has deservedly gained a reputation for reliable printing, offering consistent and dependable output that prevents costly mistakes. 15 Questions to Ask Your Software Vendor When making a decision to buy any piece of software there are a number of criteria typically evaluated. One of the most important elements in the decision process is the strength of the company that builds the software. C++ Tutorials: 3, Program Flow (If, Else, While, For) Program Flow is what you think it is. How the program will flow. HelpDesk & Asset Management Software - Choosing The Right One If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.Comprehensive Help Desk FunctionalityA good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole). Running a Program on a Remote Server Using SSH How do you run a program on a remote server using ssh?For this example we'll have two servers, one named Johnny and another named Cash. Both are running openssh. Software Review: Xsitepro Total Site Management Software It's not very often I get excited about a software program, but today I'm so excited I just had to tell you about Xsitepro, the top tool for Internet marketers. In particular, those who have been using HTML applications programs like Dreamweaver and Frontpage to produce their Internet media will find this program revolutionary in that it can at least halve your time for site development. Mapping Software: Putting Data Visualization on the Map Mapping Software Improves Data VisualizationFrom the outset, it is important to clarify exactly what mapping software is and what it has to do with data visualization. If you are looking for driving directions for your next road trip, this is not the article for you. Removing Incoming Email in MS Exchange, C# Example The purpose of one of our projects was MS Exchange handler for processing incoming email.The basic source of knowledge was this article "Developing Managed Event Sinks/Hooks for Exchange Server Store using C#" by Logu Krishnan, published to the address http://www. Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino - overview Microsoft Business Solutions Great Plains has substantial market share among horizontal and vertical clientele in the USA, Canada (including French version for Quebec/Montreal), UK, Australia, New Zealand, Spanish speaking Latin and Central America, South Africa and Middle East. Nowadays ERP can not stay as it is off-the-shelf product - it requires integration with Legacy or newly implemented systems, such as CRM, Retail Management applications, custom in-house made business systems (transportation/cargo tracking, etc). Dont Choose Adobe When Working With PDF While Adobe is the most known maker of PDF tools, your business will be much better off, if you select third party tools to work with PDF documents.ABC Amber PDF converterPriced at eleven dollars, this tool may very well be the cheapest PDF software on the planet. Document Templates Give You The Perfect Framework For Your Documents When it comes to running an office, the SOHO entrepreneur has enough on his or her plate as it is. So if you find yourself in the unenviable position of regularly having to set aside your core competencies to handle tedious, repetitive administrative duties such as creating your business documents from scratch, then you need to consider the potential benefits offered by document templates. Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free? And kill the best layout software in the process of gaining market share?***Heard about the Quark "killer"?Adobe InDesign CS2. Will it really "kill" Quark? Adobe has been saying "it will" for the last six years or so, but it hasn't happened. Is Your Small Business Ready For A CRM Software Solution? I have yet to see a business that, sometimes in spite of themselves, didn't benefit from implementing a Customer Relationship Management (CRM) or a simpler Contact Management software solution.Your small business might be the rare exception, but if you can relate to some of the following scenarios, you may be ready to take advantage of the improved and inexpensive CRM systems coming on-stream. Microsoft Great Plains Installation - Overview for IT Director/Controller Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. The Truth about Colossus: Are You Just A Magnetic Image? What is Colossus?Colossus is software licensed to about twenty-five insurance companies to aid in predicting the settlement value of claims. The insurance industry maintains it is a useful tool because it considers a great many factors, and the settlement values are just a range for use in any way the insurer wishes. The Top 5 Wrong Reasons For Not Hiring Testers Considering whether or not your software company should hire a dedicated team of testers? Here are the Top 5 Wrong Reasons why you shouldn't.We Have a Beta ProgramSome people feel that the best way to debug a system is to ship it to your customers and wait for trouble tickets. CRM 101: Customer Relationship Management for Beginners Customer Relationship Management, abbreviated "CRM," is the term for a business strategy that is designed to improve customer service. CRM is also designed to increase customer satisfaction and gain new customers, thus increasing a business' revenue. Create ASP in Minutes DBxtra goes ASPGetting to the information hidden within corporate databases has always been a problem for all levels of an organization.IT shops are constantly being pushed to produce more while having little time to accommodate reporting requirements. Windows Screensavers Explained In this article you will find some background information about screensavers and their history. You will also learn how Windows screensavers differ from other programs and how you can use it to your own advantage.
|
| home | site map |
| © 2006 |
