Home
>
Software
>
Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

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 help@albaspectrum.com ? 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 (help@albaspectrum.com), he is Dexterity, SQL, C#.Net, MS Access, Crystal Reports and Microsoft CRM SDK developer.

Mokena prom limo .. Lockport Chicago limo O’Hare

In The News:

Tech expert Kurt “CyberGuy" Knutsson says a malware app called SpyLend is posing as a financial tool, hitting 100,000-plus downloads.

Tech expert Kurt “CyberGuy" Knutsson says Clone Robotics’ Protoclone mimics humans with 1,000 muscles – too human for comfort.

Tech expert Kurt “CyberGuy" Knutsson urges you to use Apple’s App Privacy Report to see what your apps are really up to.

Tech expert Kurt “CyberGuy" Knutsson talks about how to smoothly transfer your data from an old laptop to a new one using cloud storage or external drives.

Kurt the CyberGuy offers tips to safeguard your personal information as scammers become more sophisticated with scam texts and other methods.

WeRide's unmanned electric delivery van, the Robovan W5, has 194 cubic feet of cargo space and can carry payloads up to about 2,205 pounds

Kurt the CyberGuy recommends deleting 16 browser extensions immediately in response to a report saying more than 3.2 million web users were affected by a security breach.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

A robotics firm in China claims a robot has performed the world's first humanoid robot front flip, which is significantly more difficult than a backflip.

A digital ID may be even more secure than a physical ID. Storing your driver's license in your Apple Wallet is an ideal solution for commuters.

A cybersecurity firm has shed some light on just how common tax scams have become. Kurt the CyberGuy offers his advice for how to protect your refund.

Lifesize Plans offers immersive walk-throughs that allow customers the opportunity to tour a home's design before construction actually begins.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

A man invested $4 million in bitcoin and lost it all with a single click when he was targeted by a vishing scam, which uses phone calls to trick people.

Expandable's Touchdown is a designer trailer that promises a luxury off-grid living experience and unfolds into a home in about 15 minutes.

Major employee screening company data breach affects 3.3 million people. Tech expert Kurt “CyberGuy" Knutsson explains what happened and gives five ways to protect your data.

Kurt “CyberGuy" Knutsson reveals mind-blowing tech that gives you sunlight on demand.

New malware "FrigidStealer" targets Mac computers. Tech expert Kurt “CyberGuy" Knutsson offers four ways to stay safe from infostealer malware.

Kurt “CyberGuy" Knutsson talks about how lab-grown muscles power a biohybrid hand for scalable prosthetics and research.

Reports of task scams have significantly risen in the past four years, according to the Federal Trade Commission. Kurt the CyberGuy offers some red flags.

iPhones have a hidden folder that eats up storage without you knowing it. Kurt the CyberGuy offers some tricks to free up storage on your device.

A recent ransomeware attack targeted Zacks, an American investment firm, and a cybercriminal claimed to have stolen records for millions of customers.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Researchers unveiled a new soft prosthetic hand that combines the natural coordination patterns of our fingers with the decoding of motoneuron activity in the spinal column.

Accidentally deleting a text message on your iPhone or iPad is not a problem if you still need the message. Apple has a built-in way to recover it.