Software informational articles

Microsoft great plains dynamics on invasive sql.2000 data darn ? overview for dbas - software


Some inauguration into Great Plains Software products, now Microsoft Commerce Solutions. Microsoft Great Plains becomes more and more popular, moderately for the reason that of Microsoft muscles after it. Now it is beleaguered to the whole spectrum of horizontal and vertical promote clientele. Small companies use Small Affair Director (which is based on the same knowledge - Great Plains Adroitness phrase book DYNAMICS. DIC and runtime DYNAMICS. EXE), Great Plains Average on MSDE is for small to midsize clients, and then Great Plains serves the rest of the promote up to big corporations.

If you are file bureaucrat who is behind the description on Invasive 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 apt series. If you are looking for the customers - it be supposed to be RM00101 - buyer master file, bank account master file - GL00101, Sales Legend Work file - SOP10200 - and you got the idea.

2. Use Microsoft Access. Lunch Microsoft Admission and make a link to Microsoft Great Plains tables. This will allow you to do data modification/repair. Some ancestors are demanding to use All-encompassing charge axis - we do not advocate this - MS Admission does job better.

3. Safe and sound batch repair - unlocking the batch, which was interrupted in posting. The tables: SYoo500 - batch footer - you need to adjustment Batch Category or Discernible for Rearrangement field

4. Doings table - If you have user safe in Great Plains - just ask all the other users exit and cross out ACTIVITY. BTR (Pervasive) or ACTIVITY. DAT (Ctree)

5. Gem Article link to Pervasive/Ctree - you have to bed in Insidious SQL ODBC driver from Great Plains Dynamics CD. This will allow you to organize ODBC association to Great Plains database

6. At times you have to rescue to Great Plains Dexterity- when you need ongoing data import and you do not own Great Plains Integration director or when Integration Director doesn't have the aim to deploy. This is proprietary Great Plains Software tool and advance background and you need some time invested, ahead of you can do programming.

7. Byzantine Data Migration - use MS SQL Coupled Ma?tre d' - you can construct coupled head waiter to Pervasive/ctree and then you can conceive the cursor, appearance by means of all the tables in your migration set - we by and large advise comprehension tables diagram in MS SQL Ma?tre d'h?tel (it is the same to Pervasive) and pull the data from Insidious folder using EXEC announcement in Carry out 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 Know-how Executive in Alba Spectrum Technologies - USA countrywide 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 manifold US states (www. albaspectrum. com), he is Dexterity, SQL, C#. Net, MS Access, Precious stone Intelligence and Microsoft CRM SDK developer.

Developed by:
home | site map © 2018