Find Sporting Goods on eBay
Video and Audio], Broadcasting and podcasting Broadcast On the Net

[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


broadband speed

Brodcast On the Net - streaming video, streaming audio, video conferencing, audio
Broadcast On the Net. If you are running a search for video conferencing and are looking for audio streaming or video streaminng and web conferenceing then you have come to the proper place. You can find many of the finest sites with the best conferencing services. Even find video studios or maybe the video talent to produce your program, no matter what you are looking for you can see the best streaming media here.
Brodcast On the Net - streaming video, streaming audio, video conferencing, audio

You can spend a few hours looking on the Net for information about broadband speed or you can take advantage of the research we have done for you. There are literally hundreds of thousands of web pages with some kind on information on broadband speed but much is of little value.

Jeeves is a good source for information about broadband speed but you must filter through the commercials for broadband speed and determine if that is really what you want. This means you must make a decision on the value from this particular broadband speed store. You are welcome to spend your valuable time in this research or you can rely on the fact that we have done it for you and click the links on the left side of this page.

Main Menu
Broadcast On the Net
Site Map

Affiliate Ads, Links, news, etc.

News for 03-Apr-24

Source: BBC News - Home
Wedding gift alpaca has 'surprise' baby

Source: BBC News - Home
Real-life Libya plane hijack halts hijack film shoot

Source: BBC News - Home
Your pictures: Best of 2016

Source: BBC News - Home
Yemen's displaced

Source: BBC News - Home
UN votes against Israeli settlements

Source: BBC News - Home
The longest kiss

Source: BBC News - Home
Chile anger as jailed Pinochet reign abusers ask forgiveness

Source: BBC News - Home
The technology of touch

Source: BBC News - Home
Crash survivor: 'I put my seatbelt on'

Source: BBC News - Home
Syrian girl with severe burns gets life-changing surgery


Links
Links
Links
Google

Fantasy Baseball Online | Present On The Net | Internet Meetings | Take It Right
Copyright © 2005. Name of Site here. Last Updated: Wednesday, 03-Apr-2024 00:06:17 MDT.
Medical Presentations   Medical Newscast   Fantasy Football Information