|
|
[description], Story, any other text you want to use.
Microsoft Great Plains Dynamics on Pervasive SQL.2000 data repair – overview for Database Administrator
by: Andrew Karasev
Up to the version 7.5 Microsoft Great Plains, and if you are looking to version 7.0, 6.0, 5.5, 5.0 or 4.0 - then it was Great Plains Dynamics were available on Pervasive SQL.2000 or Btrieve. I am confident that majority of database administrators know how to do data repair via Transact SQL query if you are on Microsoft SQL Server 2000/7.0, but I would like to help these ones, who have to support Microsoft Great Plains on Pervasive SQL.2000 or Ctree. 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
About The Author
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.
akarasev@albaspectrum.com
|
lcd tv
Real Time Media On The Net
This is one of the best resources for information on Real Time Media On The Net you can possibly find.
Follow our links to find more information on Real Time Media On The Net.
We hope that we have all of the Real Time Media On The Net details that you could need.
Real Time Media On The Net
|
The Internet is fast becoming the dominant medium for business and communication, but it still resembles something of a frontier, because there is little regulation. If you are looking for free lcd tv then you are doing so in an unregulated marketplace. Most efforts have relied on the Internet industry to police itself. Although there has been some notable success with self-policing, continued abuses have increased calls for government intervention. That's where our role in pre-checking free lcd tv sites comes in. Our free lcd tv provider is solid and reliable.
Some aspects of the Internet could undoubtedly use some regulation, but this task is not as simple as it may seem. The very nature of the Internet makes it difficult, if not impossible to regulate. However in the midst of this many free lcd tv retailers survive and prosper. At the same time, the absence of regulations means that everyone who uses this essentially public network can be a target for anyone who has the technical know-how and the will to invade their privacy. Privacy was foremost in our minds when sourcing the right free lcd tv retailer for you. Their link appears above.
Real Time Media On The Net Index
|
Main Menu
Real Time Media On The Net
Site Map
Affiliate Ads, Links, news, etc.
News for 14-Nov-26 Source: BBC News - Home The technology of touch Source: BBC News - Home Rockettes set for Trump inauguration Source: BBC News - Home George North: World Rugby wants more information from RFU over 'non-compliance' Source: BBC News - Home The longest kiss Source: BBC News - Home UN votes against Israeli settlements Source: BBC News - Home Yemen's displaced Source: BBC News - Home May Christmas message urges unity after Brexit vote Source: BBC News - Home Your pictures: Best of 2016 Source: BBC News - Home David Moyes: Manchester United's great traditions have gone says Sunderland boss Source: BBC News - Home Kabul nights
Links
Links
Links
|