Migrating data from Microsoft Dynamics GP into SQL Server 2008

  • Hi Guys,

    I would like to know if it's possible to move data that's sitting in the Microsoft Dynamics GP into Microsoft SQL Server 2008. If it's possible can you please show me how to do it.

    Regards,

    S'busiso

  • This will depend on your version of Great Plains. My experience is that database migrations are normally coupled with version upgrades in Great Plains. Best advice is for you to contact your reseller. They will have the best guidance for this.

    http://www.microsoft.com/dynamics/worldwide.mspx

  • Hi S'bu

    I assume you mean GP 10?

    As per our friend Google...

    Setup Tables.

    These tables have 4 prefix. IV40100 – this is Inventory Control Module setup table. Setup tables may have only one record, if this is module setup or multiple records, if this is something

    like Inventory Class setup (vendor, customer class setup to give additional examples)

    History Tables.

    These tables have 3 prefix. SOP30200 – this is Sale Transaction Header history table. When you post transactions – they go to open (optional phase) and history

    Open Tables.

    These tables have 2 prefix. GL20000 – this table stores all your open year posted GL transactions. For some of the module open stage is skipped (Sales Order Processing – here transactions when posted go to the history tables directly)

    Work Tables.

    These tables have 1 prefix. These tables are present in each module: GL, Inventory Control, Invoicing, Receivable Management, Payroll, Payable Management, Purchase Order Processing, Bill of Material. Great Plains has batch posting module – this feature allows you to save and store work (or unposted) transactions in the batch. SOP10100 – this is Sales Transaction Header Work table

    Master Tables.

    These tables have 0 prefix. We will give you several examples: IV00101 – inventory item master stores all your inventory items, RM00101 – customer master table, IV00200 – vendor master table, GL00100 – General Ledger account master table

    If you want even more info, check out:

    http://blogs.msdn.com/developingfordynamicsgp/archive/2009/05/29/understanding-how-microsoft-dynamics-gp-works-with-microsoft-sql-server-continued.aspx

    Regards,

    Zanoni


    _____________________________________________________________________
    Select 'Remember, we were all newbies once'
    From Truth
    Order by Experience

    _____________________________________________________________________

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply